When I recently had the opportunity to play Mario & Luigi: Partners in Time, it was with some dismay that I stared patiently at the title screen and came to the realization that it wasn't going to switch to an attract mode.
Perhaps an attract mode would be somewhat superfluous for this game; after all, few (if anyone) will probably ever see it displayed on a big monitor in a games store. Besides, the game is a bit on the short side, and perhaps any kind of intro would simply give away too much.
But still, it got me to thinking about some of the really great intros/demos/attract modes I've seen on console RPGs previously. Super Mario RPG has got to have one of the best ones; it's flashy and it's backed by one of the best tracks in the entire soundtrack. Chrono Trigger would probably come in second for similar reasons. Earthbound's also comes to mind; although it doesn't actually show that much, it's still quite tantalizing, and once again it comes with awesome tunage.
What RPG intros do you like?