Just yesterday a friend told me that he cried at the end of MGS3.  He didn't spoil anything but just said it was so awesome it made him cry.  Anyway, it was a bit of a surprise:  This guy's pretty stolid.  So, if you want to cry from a video game, I'd say MGS3 is a good bet.  Maybe.