For opening via the game menu- Tales of the Abyss, Man I love the song that was playing.
For cinematic opening- Final Fantasy 12- So freaking epic, just wish the whole game after it was too. I still loved the game though. lol
For opening gameplay scenario- God of War 2- One of the coolest boss fights ever for the opening fight along with fantastic music.