looking back on it, the whole Dimeo (Soprano) crime family as a whole seemed to be made up of a bunch of goofballs who paled in comparison to the new york families. it was one of the reasons that leotardo never liked them or tony, and it's also the reason why i think that (at least IMO) tony got killed in the last episode.
personally i like to think that tony got whacked, and paulie took over as boss to what was left of the family shortly therafter. i also think that the soprano crime family lost alot of power and influence after the final episode. just the way i've always seen it.