Given the status of the Family after the final episode,I don't think it makes a bit of difference whether Tony dies or not.The Sopranos,as a Family, are finished, so consigliere choice is a moot point.

If Tony lives,who does he have? Three captains,and a handful of quality soldiers.The other Families will move in and start gobbling up rackets and territory that will now be unsupervised. What's Tony going to do?

If Tony dies,Paulie,a self serving weasel,would try to take the top spot,but would wind up settling for whatever the other Families would let him have.

Either way the Sopranos would wind up much like the Westies,a big gang with some earning power,but no clout or respect in the Mob world.