The new ending is very sad, and I hated it, however from a story point of view it's how you tell a good story, if we didn't care we as the player would not be emotional invested hence the impact of our choices with V's crazy path through Night City would not matter, but they do, and it all comes to an end, not one where we ride into the sunset, but one where we fade away into the masses of npc's in Night City, we're no longer important, Night City has changed and V has changed, no one care anymore who we were, who we knew, we are dust in the wind, a shadow of what we were. THIS was the sad part, yes we live, we can get old and smell slightly of urine as Dex said, however we are no longer what we were, and never will be. I gave up Songbird to the FIA after the killing moon quest, to survive, but to pay a heavy price, Johnny is gone, lost all my "friends" no longer wanted in the world, Panam moved on, Judy is no longer there, it's a f'ing sad ending, but good from a story point of view, we are emotional invested in the story and in V's journey and that is rare these days in games or movies.
So what would my perfect ending be? well there is only two options, leaving with Panam and the Nomads, or going to space and get an ending where you can imagine a lot as it's kind of a cliffhanger.