Mass Effect 3 had some moments. They were sad, but not really tear-inducing.
Persona 4 had a few moments of sadness, but quite honestly, the Heaven level really was the hardest I had to keep myself from bawling. The music, and the implications presented (stated directly, really, but I won't...