The Sopranos worked because anti-climax was half the point of the show (although they never ended a season with this much of a "coitus interuptus feel). It was very much about the small, mundane aspects of life that eat away at us while we distract ourselves with bigger things like money etc.