Tony's motivations by the end of the series
It seems to me that one of the things preying on Tony's mind is the possibility--and dare I say probability--of everything coming tumbling down because of how directly and intimately involved those in the upper echelon of the family are in all the murders they've carried out.
It's my understanding that the mafia, at least in real life, operates by way of many layers of buffers or insulation between the hit man and the boss: the hit man gets the order from another associate who is more closely connected to the Family, who in turn gets the order from a soldier, who gets the order from his capo, who gets the order from the boss, possibly via the underboss or consigliere.
However, throughout The Sopranos, many of the murders ordered by Tony or Junior are carried out by those at or near the top. I would think that makes them all especially vulnerable to snitching on each other in the event of an arrest and indictment.