Off the top of my head...
Shadow of the Beast 2
Birds of Prey
Beast 1 (simple, but effective and evocative
Myth (also simple but worked well)
Jumping Jackson (excellent intro music!
Gods (great music by Nation XII, I also liked the intro story that can be read if you don't press fire.)
The intro of Hostages was OK too.
Those are the ones I can remember...more to come!!!