Way too many to mention in my books but I'll try to list them in point form :P
Now for the sad:
- The ending of MGS3 and MGS4 had me totally locked into what was going on. A little teary eyed maybe? pfft who am I kidding, it had me sniffling lol
- Heavy Rains ending.. need I say more without spoiling it?!
And now for a bit of happy :D
- GOW 3. As I was tearing through all the gods I would constantly burst out "ohs" and "yeaahhhsss"
- Uncharted 2. It's pretty obvious why.
- Mass Effect 1 & 2. Both games did an amazing job keeping you on the edge of your seat waiting for the next cinematic moment to happen.
- MAG. Completing my first 256 player match with a good K/D ratio made me feel absolutely great.
Now there's obviously more happy/sad gaming moments that I have experienced but I figured I would just elaborate on the current generation of games instead of going over the past 17 years :P