Suikoden III's intro immediately comes to mind. I mean, I was already hyped beyond belief when I got the game, then that song ~~. It is still one of my favorite intros.

The openings for Chrono Cross and Wild Arms also come to mind.