I got teary-eyed for FF7, 9, and 10
Also Chrono Trigger and both Kindgome Hearts

Final Fantasy X.

OMG spoiler alert please:D:D
Endings of all games WTF!!

Only three games have comecloseto making me cry:

MGS3 - When you find out why the Boss really did what she did.

Shadow of the Colossus - When you think Agro died, but mainly what happens to Wander once he kills all the Colossi.

Ico - When the Queen takes Yorda, and later on when you think she will forever be a shadow demon.

No games yet, but maybe one day in the future...

Final Fantasy X. The main theme is just too good.

Also, Star Fox: Assault made me cry on the inside when Peppy just crashed the Great Fox into that shield in the Aparoid Homeworld, but then he survives so it's all OK! =P

cry? no. sad? yes

FFVII
FFX

Pokemon Silver, Animal Crossing, and Final Fantasy X. Made me cry when I realized my cousin deleted all of my data.

Any Pokemon game when my data gets erased.
SMG. (The music)
LoZ:PH The ending.
LoZ: OoT I didn't want it to end ;-;
There might be other but I can't remember.

Postal 2. The love scene.

I give this thread a 9.7.