The ending to Doom 3: Resurrection of Evil sticks in my mind.
Not because the boss battle wasn't fun, it was. But once you've won, the game switches to a cutscene where, instead of rewarding you with an awesome death animation, the boss casually dodges your rocket blast, picks you up, savages...