FFVII and FFVIII stand out for me. A good shout for Shadow of the Colossus too.

One of my all time favourites was Megaman 2 though. The way it pans up that huge building then has that long descending note before the amazing music kicks in and Megaman is just stood there looking awesome in the wind.

Dun, da-da-dun, da-da-der-da, derrrrr!!!!