My favorite gaming revenge moment of all time was in Half-Life 2: where you finally kill that motherfucking helicopter at the end of "water hazard." Helicopters nowadays have been in war games too much I'll agree, but the reason developers keep on putting helicopters in their games is that they are all trying to re-create that one moment with the original motherfucking helicopter in Half-Life 2. That thing hunted you, caused you grief at every turn, it dropped bombs in front of you when you were going too fast to steer out of the way, made sure you could never stop to catch your breath, killed you thousands of times and finally at the end of that boss battle it died. Never has anything been quite as satisfying for me and I was so ecstatic with sheer joy afterwards that I had to get out of my airboat and whack it with the crowbar a few times.
There are probably better revenge moments in other games. I mean, I haven't played much, I'm only sixteen. Nevertheless, for me, that has gone down in history as one of the greatest "fuck yea" moments of all time (along with stabbing ganondorf in the forehead at the end of The Wind Waker).