well theres no real scene thats more emotional:

seeing clouds life made him seem pathetic in ff7 and that kinda made you feel sorry for him, then theres aeris (or aerith but i prefer aeris) when she dies by sephiroth

Then theres the relationship between the boss and snake which highlights some real tearjerking action to some people

Theres also the end of ff10 where yuna cant even properly hold tidas

There are other games but its too late to think of them

I'd say when Crono died in Chrono Trigger. That was a really emotional event even though the character didn't speak. He was a highly respectable guy, it was sad to see him die. Luckily there was a sidequest to revive him.

MGS 1 when meryl gets shot by sniper wolf

For me it would have to be in Battlefield 1942 when NPC #4 shoots NPC #9. real deep stuff.....heh jk
Probably would have to be the beginning few chapters of the Darkness and the last 5 minutes in that game.

The end of Lufia 2 for the SNES. Also the Opera scene from Final Fantasy 6.

__________________
Don't hate me because I'm evil, hate me because I do it better than you.

Definitely when Areith dies in FFVII. Just when actually found a person... stupid tifa

Final Fantasy VII: Crisis Core ending. Great storyline and then it just ends... ='(

I simply bawled when I saw the last scene of Final Fantasy X because they sent Auron away and he was the only character I enjoyed; Rikku was nice eye candy but she was too ostentatious for a thief, Yuna was wearing a kimono that traditionally symbolizes modesty but she has a black bra peeking out and she just came across as the virgin / whore paradox / stereotype, Tidus was too boyish and fickle to be a true hero ... the list goes on. I think I was a little hormonal, though, because I rarely cry, even during very dramatic films.

Oh, wait, Lulu was tolerable even though she seemed like a goth-pop queen, and Kimahri seemed to be seriously bad-ass.

There are two of 'em, which have almost made me cry...
HITOTSU is THE scene with Aerith in FF7
FUTATSU is the ending of HL²Ep2...that was really kinda...brutal...

I toally agree CC was so sad, i wanted to cry, and zack is such a alsome character.