wow, the choice
okay heres a few (not in any order, as there all great)
- Super Frog
- Perihelion
- Hired Guns
- Skeleton Crew
- Project X
- SotB2
- Flash Back (Ralph's work is sublime as is the game!)
- Jaguar XJ220
- Blastar
- UFO: Enemy Unknown (preffered the ps1 version for music though)
- Escape from the planet of the Robot Monsters
- No Second Prize
- The Lost Patrol
- Space Hulk
- Wing Commander
I am sure there is a whole lot more
controversially I would say that a lot, if not all, Bitmap Brothers games have an amazing title music splash / intro... but it gets really sucky with in-game music or there is a distinct lack of it.