Even though I do not like FFVIII, the opening was very nice. Mainly because of the music. And the Squall - Seifer fight scene was cool.

I also like IX's opening, with the boat, and the storm, and all that stuff. Good times.

Overall.. I'd say FFVI's is my favorite, short and sweet. Right to the point. And the music that plays during the opening credits is awesome.

As for ending? FFVI is my favorite again.