Lots of scenes in FFIX made me feel that way, but the very ending and one particular scene involving black mages near the end particularly made me really emotional.
Oh, and since someone already went into anime territory: Grave of the Fireflies is probably the most emotional I've ever been in my life.
FF IX I would agree on. The Black Mage you are referring to I believe was on Disc 2, right after the fight against the Black Waltz and Viva watches as numerous "Black Mages" are blasted and cast off the airship. This is so far, the only Final Fantasy I could get my girlfriend to play through. She absolutely loved it and found it extremely emotional, specially when she thought the worst for Zidnane during the ending only to recieve her very much sought after happy ending.
Yea, FFX was good. . . Too bad they ruined it with FFX-2 :(
To this day, still the only Final Fantasy game I have played where I yearned for a sequel. Too bad the sequel was not what I expected, although I got the ending I wanted, so all ended well for me anyways.
iPhone = Great gaming device. Don't agree? Who cares, because you're wrong.
Final Fantasy VI (iOS), Final Fantasy: Record Keeper (iOS) & Dragon Quest V (iOS)