The Legend of Zelda: The Wind Waker/Heartwarming

Link's grandmother gets sick and delirious in the first half of the story. When you get back, she's begging you and your sister not to leave "your poor grandma all alone." If you cure her with a fairy,^[1] she gives a real Tear Jerker of a speech about how she'll try to be strong.
- What makes it even sweeter is that it's a rare moment of Link having someone else show parental love for him. After so many games of him being pretty much alone to go risk his life in monster-infested dungeons and temples, how many times has he had someone say "I should be the one taking care of you"?
- Even the practical, non-emotional reward for doing this is rather heartwarming: after you get Grandma all better, she whips you up a batch of your favorite home-made soup! (The fact that this is 2 helpings of the game's ultimate healing item simply makes this a Karmic Jackpot, and a just reward for your kindness.)
The entire ending: from the King's Heroic Sacrifice, Hyrule's destruction, and finally Link setting off with the Pirates to find a new land everything fills you with a sense of hope for the future.

King: I have scattered the seeds... of the future...

Pretty much any scene with both Link and Tetra in it can be enough to make any gamer's stone heart turn all mushy...
The whole final fight. You were not fighting for Hyrule: all that was being destroyed around you. The only thing you were doing was fighting for your own lives so you could go find a new land.
Don't forget the moment when you finally rescue poor Makar from the Forbidden Forest.