Please don't list this on a work's page as a trope. Examples can go on the work's YMMV tab.
Tear Jerker: Golden Sun
One after another gets delivered once you get the cannon in Golden Sun: The Lost Age. First, there's the poor fate of Prox, teetering on the edge of infinity with eternal winters. Then, once you get into Mars Lighthouse itself, it appears all frozen, and somewhat counterintuitive. Finally, you meet some Fire Dragons, and battle them, and to no surprise, it's Karst and Agatio. The the final boss is Felix and Jenna's parents and Isaac's father, as a dragon
This troper teared up not ten minutes into playing the first game, when the Mt. Aleph boulder destroyed a dock where Isaac's dad, Jenna's parents, and Felix were standing. Of course, the game had to use slow-motion photos of the parents hopelessly trying to escape as the huge boulder came hurtling down inches above their heads. Jenna and Dora's tearful reactions didn't exactly help. Fast-forward to the last ten minutes of the second game, where this troper cried twice:instead of rejoicing over the defeat of the Doom Dragon, the characters are rocked simultaneously by the fact that a) their parents were alive after all, but b) congratulations, they just got killed by their own children. Miracle of miracles, their parents are revived when the lighthouse is lit. However, this joyful reunion is quickly crushed when they all go home and find that their entire hometown has been destroyed by a friggin' volcano. To everyone's surprise (again), it turns out that no one died after all, and smiley faces ensue. But damn, that was emotional.
The dialogue right before the ending CG... Garet is the one guy who didn't suffer anything through both games, not even from the boulder incident, his family is whole, functional, happy, was safe at home and happy to see him when he visited in the first game. When you reach Vale at the end, for a moment, the group (and player) is led to believe that everyone in Vale died - so while Isaac just found his dad again and Jenna and Felix finally got their parents back... Garet realizes he's all alone in the world. Then the girls start teasing him, which comes off as shockingly cruel, but it's because they've seen his family, safe and well, hiding a little way off - the mood whiplash is very intense.