For video games, in terms of (intentionally provoked) rage, Fallout 1. Going through hell and back on a nightmare of a quest that saw your inexperienced Vault Dweller go from zero to hero... only for THAT to happen. Listening to "Maybe" by The Inkspots as the credits rolled, I felt sucker punched, but oddly, in a good way.
In terms of sheer awe, Fallout 2 (bit of a trend there, but I digress). It's rare a game makes damn near EVERY choice you made count for the ending, but whoever you sided with, whatever you did, those you killed, those you spared, the myriad of ways you approached the completion of the various quests, all was there on the screen, gloriously narrated for your enjoyment (or suffering, depending). "And the drifters, well, they just drifted away..."
But the most emotionally moving endings for me came from the Bioshock games; specifically, the good-guy-to-the-hilt endings. The narrative for each made those endings matter to me in a weird way that few game endings can accomplish, and I'll damn well admit, Bioshock 1's ending made me tear up. I guess when you spend an entire game talking about and diving head-first into the concepts of extremism in philosophy and what that means to the self, to the family, etc., just the right framing device for your endings can make all the difference.