Sierra Madre wasn't bad IMO. It was loving hard, but the atmosphere was so loving spot on. That place was legit terrifying.
That said, I would never play it twice. It's good for one playthrough only, because after that the enemies stop being scary and start being annoying.