The main theme from Speedball II still is a favourite of mine.

Most of the music in Dune is great, too.

As is the Turrican 3 end credits theme

Other game music I liked: All Shadow of the Beast themes, Xenon II intro theme, Pinball Dreams, most Turrican music, most Monkey Island music, Utopia and Wing Commander.