Oh, god, don't remind me. It's hit me so much harder when I was a female MC and had made one of my dear party members my boyfriend. Yeah, that wasn't a good idea. Bawled my eyes out.
Though the game that got to me the most was probably Xenosaga III. I mean, really, the ending was just so...