Being subsumed into Alt or Mikoshi are equally bad.
Being absorbed into an AI is very different from being put in storage as an engram. With the latter, you have a chance of returning to the world, with the AI you cease to exist as you.
Self-sacrifice for Johnny could be seen as noble,
Or that's what the engram wanted you to think
Goro's tone is chilling at the last meeting, almost fearful in Corpo CYA mode, and has returned to the Arasaka fold, having seen what his boss was willing to do to his own Prodigal Son.
He was a little shit anyway, fuck him - and he knew his life was over one way or another. Also, he probably felt it was a noble self-sacrifice (echoing the sacrifice Johnny asks of you, in a different way) - a kind of redemption for him, having fucked up the family so much. I must admit I've only seen the Goro version once on YT, but I didn't get that impression, I felt he was just solemn and sympathetic to a friend making a difficult decision.
Returning to Earth to live out a short, brain damaged life on Arasaka's leash (and those endgame voicemails need fixing) is clearly worse, or at least less human than the final Avocado path of love and family out on the range. It's implied that hope for a 'cure' is nil in either case. Frankly, you were dead anyway. The time after getting shot was gravy.
But as an engram you have a chance of resurrection in a body as a human being again, in fact a chance of literal immortality; no chance of that on any of the other paths.
But it depends I suppose. My V felt that returning to earth as a plain human with dignity intact, and Johnny out of her head, was better than any of that cyberbollocks, even if it was short - she was heartily sick of it by the end of the game, kind of in Luddite mode.
Bittersweet ending to be sure, but not the worst. In fact, I don't think you can really rank the endings, they are all fairly bittersweet - except the one where Johnny gets to ride off into the sunset having taken over your body, that's pretty cheerful. For him. The Panam ending would prob be best if you were a male V really in love with her, but my V was femme and just thought of her as a close friend.
And then of course there's the matter of not wanting to risk the lives of the friends you'd made - Panam, the Afterlife people, etc. Avoiding unnecessary death there is another good aspect of that ending.