I'm surprised at how many other people liked the opening to FF8. It was a great opening -- and it helps I really like the game. The ending was pretty good also.
FF4 and 6 also had very good endings.
The Ninja Gaiden games also had good openings and endings, as previously mentioned. Metal Gear Solid had a good ending.