The end of Twilight Princess is permanently embedded into my mind. Just the silence of Ganondorf standing with the sword plunged through his chest is incredible and a little haunting at the end of that game.
That, and when my dad showed me DOOM. That was a good day.