Yeah this is one of my biggest gripes with the game.
There's not a single ending where V comes out victorious. V is doomed from the start. In literally every ending V gets fucked in some way or another. This game would've resonated so much better with me if we were able to get rid of Johnny without any consequences.
That would've ruined it ( for me), entirely. You walk away, happy&free, without any cost.
I think the endings are one of the best, emotional and engaging, I've seen in video game. ( I put them even above TLOU). In other rpg, endings are more or less "roleplaying flavor": ( like in Bloodlines or New Vegas) achieve same goal with different faction. But there is nothing "of you" in it.
Every ending here is very personal, letting you define who your character ultimately is and what you value more in life.
Burn out in blaze of glory, for fame? Family and friends, at expense of losing yourself? Survival above everything else? Self sacrifice for someone close to you? Or give up, realizing none of it has any ( lasting ) meaning?