FFVIII's is still probably the best video game opening I've ever seen.

Resident Evil: Code Veronica's was pretty awesome the first time I saw it, though it hasn't aged even a fraction as well as FFVIII's has.