Opening: Ocarina of Time
Ending: Shadow of the Colossus

Anyone can open/end a game with explosions/sparklers. These two show you how to really get the job done.