I love the FFIV opening where the five Red Wings ships are flying together. The music is during this sequence is fantastic, as well.

The FFVII opening is also really good.