Twilight Princess made me semi depressed after it was over. I remember that I was 12 and I kept replaying the ending almost daily because I wanted it to continue like I was in denial. I wasn't ready for the emotional farewell in the middle of the credits or some of the twists/reveals after the final fight. I was also displeased over the way Ganondorf was handled in the plot which was also a cause for confusion and incomprehension.
Mass Effect 3 seriously depressed me, no, it made me a cynical fuck. It permanently damaged my expectations to ANYTHING regarding the anticipation of the continuation of a story that I "think" I like. I was SOOO fucking ready for Mass Effect 3 with my save and all after having played and replayed 1 and 2, where 2 just hit a real nice sweetspot of being like 1 but also a blend of action and exciting stuff with deep characters and deep RPG dialogue trees. But Mass Effect 3 immediately seemed off to me when I loaded it up in march 2012.
Autodialogue, partly better but also weaker graphics, wild shift in tone from optimistic but dark sci fi to BATTLESTAR GALACTICA'S SHAKY-CAM AND EXISTENTIAL DREAD. I knew the Reapers were coming, seriously I did, but I didn't expect it to happen the way it did and practically doom the world from the opening cutscene, and I could not believe the way the writers went about making the characters plan around it. It just presumes that everyone should think Earth is No. 1 priority which emotionally did not make sense for the character I had established nor his alien companions, and there was very little of that gung-ho friendship and "working together" in the tone, it was all telling and no showing instead. It only makes sense that it all came down to earth by the very final mission in the game due to a number of unexplainable contrivances and then it goes from having great middle acts that go back to what made 1 and 2 feel like Mass Effect only to return to the brooding, shaky-cam, overemotional and depressing tone of the start.... But then they had to make everything worse by attempting a deep "philosophical"(?) sci-fi twist ending that revolves around the information that eatablished the premise of the original game and they turn everything you assumed about the Reapers 180 degrees in a shyamalan twist that makes some convoluted sense on a canonical level but is deeply questionable and imo worse than what I thought I knew, but on an emotional and thematic level it closes the whole Mass Effect arc on a nonsensical "so deep you can't even see it" level. It was a gainax ending, it took something that was perfectly serviceable and messed it up into a conclusion that doesn't drive home the themes that all 30 previous hours handled. It goes from having a universal message about the goodness of sapience and working together as a society, working out one's differences instead of infighting etc., to some useless subject with no footing in reality about the nature of organic beings vs synthetics as if "that's been the true theme all along" which was especially awkward because this was a theme and they concluded it earlier in the story with context and several impactful player decisions across the last two games... But the ending is not contextualized properly. It takes something you assumed was true and without explanation decides that "now it's this thing instead" and you make your final decision with only the context of what "this thing" is and zero ties to the rest of the narrative across all 3 games. It's as unaatisfying as it could get and it happened so suddenly barely anyone anticipated something like it.
I'll admit, I thought 3 was a little too straightforward in its focus on "war" and stuff, so I was actually begging for some more sci fi and existential ideas... So maybe I could see where they were going directionally, but the execution was so off that I can't believe it got produced, even if it was a rushed product. How it got approved by all 5 or so leads is something that only tells me that there were hacks among BioWare and that alone has entirely damaged that amazement and respect I used to feel, and in turn has made me a skeptical cynic to almost every other game I look forward to.