I really like the Warship Gunner 2 intro. Sadly, it doesn't appear to be on youtube (<.>)
Basically, 2 fleets fight, the first fleet gets obliterated by the obviously evil second fleet.
Cue one Destroyer coming out of the smoke, the last good guy ship. Music ramps up, and all hell breaks loose as the one ship obliterates all the bad guys. Sums up the game quite nicely.
On top of that, if you let it idle at the title screen, it's goes to attract mode and plays a mission with one of your custom designs. The AI very impressive while using your ship, since it can fire all the guns simultaneously.