VII's was the most memorable. To see this gigantic futuristic city only to find out you are a terrorist trying to blow part of it up. Good stuff.

XIII's was also pretty decent and it was one of the best parts of the game.

VIII's opening video is the best though simply for the music.