FFXIV, over and over. The kind of nobility and self sacrifice displayed in that story has set me crying several times. Honestly, I can feel it a little bit just thinking of some of those moments, but I try to smile through it.
There’s three big moments in the game that I think got it for me; Amaurot, Close in the Distance, and The Dead Ends. But there’s plenty to feel more invested in, especially with all the side quests that focus on so many personal endearing struggles. Heck, even the Dark Knight job storyline has a great emotional payoff to it.
I can think of three in Shadowbringers alone, Amaurot, the conversation against the rock in upper Kholusia, and that one part right near the end, the one that requires channeling a large amount of environmental power.
(Trying to avoid spoilers while being unambiguous)
Oh goddess and the role quests, particularly the healer one.
Shadowbringers was just so good. The parts that really get me were in 5.3 and just... everything. Probably the best patch the game ever had. One quest in particular left me a blubbering mess (returning a certain crystal), even thinking about it now chokes me up. The voice acting is also just top notch the whole expansion.
Endwalker also had several moments that got me and basically the entire last zone (and the music. Omg).