Edit: And House of the Dead Overkill, NSFW, there's more of those funny sequences during the game
Edit: Burning Rangers has a pretty awesome, anime style intro
And more funky sega pop in Daytona USA
Star Fox intro on SNES is etched into my brain. Short but epic.
Another world, have to second that.
Love Rotoscoping.
Case of the Serrated Scalpel, too