The best game theme ever is from splatterhouse 2.
http://classicgaming.com/splatterhouse/sp2prelude.mid
It's not of the best quality there, but it's alright. Download the rom and listen to it
Edit: Splatterhouse 3 has a really good theme too...as does comix zone
