Well it's not actually ingame music, but I'd have to go with
The 7th Guest! The songs:
The Game and
Skeletons in my closet are really excelent. They're on the soundtrack on the second CD.
BTW - if you don't know the songs:
Skeletons in My Closet and
The Game