Yeah realms of the haunting is quite ambience setting and had good graphics for the time too. Actually the slightly grainy graphics make for better atmosphere I think. 4 CDs for what some people would just declare a 3D shooter because you had a gun of sorts and could shoot things. I got sort of stuck after having travelled to hell (or whatever it was, at any rate you were outside the house) and then back again. There was some creatures which didn't mind you shooting them, the only way to avoid their wrath was stay out of the room or stand on the pentagrams. Couldn't get further from there.
How about undying though? It's a fairly new game. I haven't tried it. Is it up to par gameplay wise as well or only atmosphere wise?