I agree, but after playing through the trilogy and wrapping up the third with 100+ hrs, it hit hard. I wish I could have experienced a good ending first. Who knows though? Maybe I’ll look back and be glad for it. It was a masterpiece of story telling and like you said, probably the most realistic ending.
Fallout. The one that comes to mind is the Fallout 4 menu music, but I’ve gotten that feeling with nearly all their games.