I'm a sucker for the Final Fantasy game endings.
Bawled my eyes out over Crisis Core, even though I'd already played FFVII and knew how it was going to go. Aeris in VII had me sniffling as well (I was 17, alright?). Quite a bit of Dirge of Cerberus as well, if I'm honest, but a lot of that is due to rabid Vincent fangirlism.
Ending of VIII, I was fine until the cutscene went to Laguna standing by the gravestone, then I went to pieces. And X when Tidus leaves - I didn't even like him all that much, but that was apparently no bar to Square tugging at my heartstrings.
Otherwise, there's been a few bits in Silent Hills and Mass Effects that get me. Oh, and Dragon Age: Origins, too. I did a save where I let Alistair kill the Archdemon to get the achievement, and couldn't make it through with dry eyes.
It occurs to me that I'm getting remarkably girly in my old age.