My favorite intros would be The Legend of Zelda: Ocarina of Time and Majora's Mask
Ocarina of Time
[youtube]http://www.youtube.com/watch?v=3avXA-S4NrU[/youtube]
Majora's Mask
[youtube]http://www.youtube.com/watch?v=PVCHGGv0W_c[/youtube]
_________________
"I'm gonna give my best and let the good times roll out."