ROTH is a huge game too. You'll be exploring a mansion at a few different times but most of the game is spent in what is basically, heaven, hell and the places in between.
Man... I want to play through it again now.
I'd kill for an OpenGL source port of this game to run it at a higher resolution. The textures and sprites are actually really good. Running at 640x480 doesn't do it justice.