Final Fantasy VIII is still probably the best video game opening I've ever seen. I can't think of another one that had as much of a sheer wow factor combined with getting me absolutely hyped to play. This is all through the lens of playing it in 1999 mind you, but it holds up surprisingly well even today.