In the Cyberpunk universe, for runners, it is better to die in a blaze of glory with a crazy reputation than to die of old age.
This isn’t well conveyed in the game though, so I can see why you and other people feel that way. But happy endings are fews and far between. So it makes sense that there isn’t a truly happy ending.
This is why I feel that in this case, the secret ending is the best ending.