Final Fantasy 8 has an awesome opening movie as does Final Fantasy X and X2. Those IMO are the best in the Final Fantasy series.
Other great openings are:
Persona 3:
http://uk.youtube.com/watch?v=r7ZLA5FX_v0
Persona 3 FES:
http://uk.youtube.com/watch?v=DW-pfcLNbj0
World of Warcraft Online:
http://uk.youtube.com/watch?v=oyWWiZAuroA
Lost Odessey:
http://uk.youtube.com/watch?v=x8sdYvrRbqE
I cant think of anymore, Im sure to add more later lol!
Other great openings are:
Persona 3:
http://uk.youtube.com/watch?v=r7ZLA5FX_v0
Persona 3 FES:
http://uk.youtube.com/watch?v=DW-pfcLNbj0
World of Warcraft Online:
http://uk.youtube.com/watch?v=oyWWiZAuroA
Lost Odessey:
http://uk.youtube.com/watch?v=x8sdYvrRbqE
I cant think of anymore, Im sure to add more later lol!