I don't know if it counts as a startup screen since it's from the arcades (which I guess would make it an Attract Screen), but I like the opening of Aero Fighters 2. It's short, but I remember playing this as a kid and I always thought the opening was awesome.