This, Metal Gear Solid 3, Metal Gear Solid 4, Kingdom Hearts 1 &2, Shadow of the Colossus, Final Fantasy X.
You named some good ones
Kingdom Hearts 2 was the other game that made me feel some kind of way. It didnt bring me to actual tears like MGS4 did. I still cant believe that it actually had me tearing up like that. I actually had to sit the controller on the ground.