I've never cried actual tears, but I've gotten that throat/gut ache pre-cry feeling a handful of times.
The end of Walking Dead, the Mordin bit in ME3 and - this one is a little less common - the third time I played DA2 (I can't explain why I played that that many times, but I did), I picked the "goodbye" option at the serial killer plot, and the line turned out to be totally different than what I'd expected and it just slapped me. I mean, the first two times I played that scene I thought it was poorly done, I complained about it as a missed opportunity, the whole thing - but fuck - it *got* me that third time.