Verytex and Midnight Resistance on the genesis both have spectacular music, and those are pretty average games.
Jinmu Densho on the PCE has pretty inspired tunes. I think the sound engine is messed up (much like the rest of that game) where if you let the songs play long enough, the percussion goes off-sync with the rest of the music.
I will edit this post when I think of more.