Tales of the Abyss is great at making me tear up so far.

I also tear up whenever I replay an emotional scene, a character dies, etc. The standard stuff.