I mean, that's kinda the point of Cyberpunk right there. It's written all over the game, and games, or other media just like it: NO FUTURE. The MC either dies, or becomes obsessed, or becomes consumed by the very thing he sought out to rid himself of.
Except, again, this is supposed to be a 'choices matter' RPG. Cyberpunk or not, it was a bit of a jebait with how much they talked about 'better RPG than witcher' and 'best RPG we ever made', but all we got was a linear story with 3 flavours of dissatisfying ending.
Like yeah, Nerevarine, Dragonborn, Dragon Age hero, Shepard, Vault Dweller, Witcher, Kiryu and other iconic RPG characters also die at some point, but that doesn't mean the game has to focus on that. The point of a story is to be enjoyable; These endings were not. You can be dark and still be enjoyable. This story fails at this.
The only reason the story is even -decent- is because the characters are written and acted extremely well; The actual story they're a part of, if you give it any amount of thought, is actually really rather boring, predictable, and ends in an insulting way.
The staple of cyberpunk genre is attempting to rebel against corpo tropes, but I guess accepting that 'its bad because its cyberpunk' is just what you do, because either you die young or live long enough to accept the corpo way.
Johnny Silverhand's story is attacking Arasaka and dying, they're -literally- rehashing his arc with this game, except you don't even get a nuke to 'go out with a bang'. There's a reason no one makes games about where you're a corpo accountant and get gunned down by terrorists, because that'd be a very boring game. The same reason no one makes 'realistic' games about having a terminal illness. It's just not an enjoyable experience.