The moment in Final Fantasy IX, when the third Black Waltz massacred those poor black mages.
The look on Vivi's face when it happens is enough to break your heart, despite the fact that he's The Faceless and you can only see his eyes as he watches.
His body language in that scene thoroughly makes up for his lack of a face. Watching him press against the window as the mages fall or stand in front of the one hat on the railing is just heartbreaking.
The Black Mages suffer even more when Kuja gleefully admits that he tricked them into his service with the promise of lengthening their short lifespans, saying they're going to die soon and there's nothing they can do about it. The Black Mages have no choice but to accept their fate.
The moment where Queen Brahne dies on the beach outside her escape capsule. Yes, she might have gone mad with greed and killed thousands of innocent people, but that's still a young girl losing her mother and the only family she has left.
Also the aftermath, including the destruction of Alexandria, giving Garnet a Heroic BSOD moment and causing her to go completely mute from the trauma.
The ending of her period of being mute was also a tear-inducing, but for the completely opposite reason.
And, yes, the moment when Zidane stays behind to be with Kuja in his final moments, who only just realized he had wasted his life and it had meaning just before he died. Like in the example above, Kuja is still Zidane's only real family, being his 'big brother'.
Not quite Zidane's only family. Which brings us to another tear jerker. Their little sister walking along one of the now dead Iifa tree's roots, telling Kuja that what he did was wrong, then thanking him for showing that the genomes weren't created for the wrong reason.
That scene gets to me too, largely because it's so unexpected an act of compassion, given the genre and the way RPGs usually play out. I don't know why, but just the fact of Zidane's compassion toward someone who had shown him and his friends nothing but cruelty is enough to make me tear up.
The final words of Vivi, saying goodbye to everyone and wishing they could have gone on more adventures. It's implied that he never lived long enough to see the reunion of Zidane and the others.
"How did you survive...?" "I didn't have a choice. I had to live. I wanted to come home to you. So... I sang your song. Our song." Oh goddammit. *sob* (qualifies also as a Heartwarming Moments).
One of the most well-remembered parts of the game, where Zidane's True Companions break him out of his Heroic BSOD after he discovers his true intended purpose as the 'angel of death' and the destroyer of Gaia, telling him that since he always believed in them, that means that they're going to believe in him too. All while the famous track of You're Not Alone plays.
Dagger: "You've always protected us. But you still don't understand that we looked out for you, too! We watched your back while you watched ours. And we believed in you the same way you believed in us! Just like you protected us... We want to protect you."
May just be me, but for some reason when Quina runs away at Cleyra rather than get into the life saving bubble he was struck with unreasonable sadness. Partly due to the fact that Quina refuses due to be scared of heights, which made it even worse. Watching that tree explode was so damn hard.
The destruction of Cleyra. There's something just plain wrong about destroying the home of what were essentially a bunch of peace-loving, nature-worshiping hippies.
Even worse is the fact that even if you get all of them to the top of the tree, you've just doomed them to die at Odin's lance.
Not quite, they escaped and can be seen around the world map at various places. I can remember seeing one of the oracles in Daeguerro and the couple in Lindblum (complete with children)
A smaller Tear Jerker is near the end of the game, where you learn that Morrid, the Cool Old Guy who helped you earlier in the game and collected rare coffee, had died in an earthquake caused during the course of the game.
The destruction of Lindblum is the most devastating scene in the game.* It's made even worse by the aftermath. Where any other form of media would have an implied holocaust or only talk about it, in FF9 you're forced to walk around a destroyed Lindblum, while the citizens give you short but horrific anecdotes about the attack and the Alexandrian soldiers waver between My God, What Have I Done? and bragging about their superiority. The stories include a little girl in the very first screen asking for her (absent, probably deceased) mother not to leave her alone, the synthesist's father having lost the use of his hands, the pickle selling woman having been blinded, and that's only three out of dozens of potential conversations. The entire Industrial District was wiped out. Just think about how many people that would be and what that means.
A rare one for the enemy side, but Kuja learning that he's going to die soon, and the cackling fear in his speech when he realizes that Garland isn't lying about it, causing one of the most triumphant and saddening examples of the Villainous Breakdown I've ever seen
"Freya, you say? I believe this is the first time we have met..." Ouch. Followed by Vivi's innocent, "What's the matter, Freya? Are you crying?"
(during Kitchen ATE) "Grandpa... I don't want to be alone anymore... Help me do this right."
The black mages' understanding of death, or, as they call it, "stopping."
"One day, Mr. 36 stopped moving. My friend who knows a lot of things says that this is what "death" was, and that we had to bury him. Mr. 36 is buried under the ground now, but I don't understand why. He's going to come out again one day, right? When he does, I'm going to wash him off in the pond."
Mr. 288 explaining what a cemetery was for to Mikoto gets me teary every time:
"...You're right, but I don't think we build cemeteries for the dead. Sure, it may seem pointless to you, but... How can I describe it? It's so that we can think like this: 'We'll never forget you. We'll remember you every time we stand at your grave. And we won't let the fear of death, which each of us knows, stop us from living our lives. ...Because my friends will remember me when I'm here.'"