One of my favorite pieces of video game music actually comes from a classic arcade shooter. The very first stage of Darius in the arcade is awesome. If you go to YouTube and do a search for "Captain Neo," you can listen to it. Taito's in-house band and game music creators, Zuntata, they're really awesome.
Another favorite is the first stage music in Gaiares, a Sega Genesis shooter.