Shadow of the Colossus has been a long-time favorite of mine. I also liked Fatal Frame. I think I also remember enjoying Rule of Rose, but I have very little memory of that one. I just remember it was weird.