Puzzles in Horror Games

What would you consider a good puzzle for a horror game, because I feel that many of them just exist for more play time. Even the coin puzzle in SH2 remake just felt annoying to me (I am dumb) and I feel did little to add to the atmosphere. If anything it just made it feel less scary during that time.

What makes a good horror puzzle?