I've always liked the intro to Persona 3. Probably one of the better ones out there actually. FFVII's was good too. And FFVI for that matter. Even just the mode 7 scrolling combined with whatever variant of Terra's theme was playing, I'm terrible with names.