Glad I could help! If you're looking for horror games with good puzzle design, I think the original resident evil had some good puzzles. I 've only played a little bit of it, but it had some good stuff.
Also, although they're not necessarily horror games, point and click games like Myst are focused almost entirely on puzzles. So you might find some inspiration there.