I have two games that I always allow the beginning intro. I love the beginning of Chrono Cross for the Playstation. The music and video is worth watching over and over. Its fast paced and gets me pumped up.
I also love the intro to Final Fantasy X for the PS2. By far the best music in a game ,IMO. The characters all sitting around the camp fire with the introductory piano theme. Tidus touches Yuna's shoulder than walks to the top of the hill, it seems to evoke some emotions in me.
Anyone have any favorites?