Double Dragon 3
has an awesome title track with rain. I actually prefer the cutdown version that was used in the attract sequence "mod.titlemusic v2" rather than the original longer version (in the bonus folder).
I also really like the Snow Bros
intro music (the track called Spotlight) - if you leave it running, it gets really funky!