I hadn't even heard of this movie until I stumbled across it on late night TV and found it more than adequately funny. As a Sicilian, I got over any real sensitivity on the mobster subject long ago. The beautiful thing about Martin is that he can be absurd in almost any role he plays and still be likable and funny because of that very absurdity. This allows him to doing characterized spoofs of even evangelists with relative impunity. The magic formula is that just about everything he does in a role would supposedly make one dislike him, but one doesn't.
I am not exactly sure what failed to make this movie more of a box-office success, or why it got so little attention. I would think that there would have been enough Martin fans to give it a good flying send-off and kept it there. Possibly it was due in part to the fact that by the time the movie was made, the movie-going audience demographics had started to change considerably. Adults were becoming more likely to rely on TV and video-tapes for their viewing fare, unless they thought a movie had the scope and grandiosity to benefit from the very large screen. The movie houses depended more and more on the teeny-boppers who relied on them as social outlets or at least just another place away from home(ugh!). And most teeny-boppers lacked many of the points of reference that would make the whole New York/wise guy/FBI/not really bad guy shtick really funny. Then of course it was also the beginning of end-less violence and computer generated special effects which youth saw and popularized as an extension of their video games.
Considering the more recent offerings such as Bewitched, this movie is on a different plateau altogether. If you are in your forties now and have been exposed to the Sopranos, by all means see this movie if you missed it originally. Chances are it will make you laugh, hard. And is that not what a good comedy is supposed to do?