Two in FF6-
First is the Opera scene with Celes, to this day I have to keep a tissue whenever I hear the hauntingly beautiful score that plays during. The play itself is a bit heartbreaking, the way that her character clings on to the memory of Draco and when all seems lost and for naught, there he is. Just as he promised, he has returned in her darkest hour.
Second, Cid's death and the following attempted suicide of Celes after. You're introduced to a side of Cele and Cid's relationship that you didn't quite see before, like the Cids before him, he's picked up a sort of fatherly role to her and grows on the player. But if you ail at keeping him healthy, he slowly passes away, thanking Celes for his time with her and that's when it dawns on you. YOU did this, YOU failed to keep him healthy. Going back and actually accomplishing it, while a weaker ending to be sure, drives home this point. Heart-broken and devastated, Celes realizes that the last person she had in the world is gone. She is alone now. Alone in a dying world. So she makes her way up to the cliffs to end it there. And that's when you notice it, it's a step by step recreation of the Opera scene, music and all, as she makes her up. But all is not lost, as she hurls herself down the cliff, she is somehow saved from her fate. Awakened once more on the beach, she finds the headband of Locke, her love interest, that inspires her and renews her drive before she sets off into the new world thanks to...Thanks to a craft that Cid worked himself to death in order to build for her, for the Celes he wanted to live on.
Manly tears were shed.