I think you're coming up against the genre there. Folks who love the themes enough to make an entire game out of it aren't going to dump them for mass appeal. Much like how Lovecraftian horror ends in the madness or death of pretty much anyone involved, or how in high fantasy practically no major "good" characters die at all, unless it drives the plot (the classic "plot armour" that sours my experience of such stories).

In what I'd consider the happiest ending, you've bought V time to enjoy the remainder of their life relatively stress-free, surrounded by family, their love, with all escaping Night City with the distant hope of a cure. That's about as peaceful an ending a Night City Merc can hope for, and I find it hard to believe that it was pointless fighting for that.