I could never get used to Ravenholm though. Thinking about it even now years later stresses me out a tad.
To be fair, I did enjoy it and could feel the intent of it being the horror section. I could see it usettling me if I played it at the time, but I see a lot of people saying it holds up really well so I still feel I've missed out on something.
If you want a similar feeling from a more modern game I recommend trying Prey (the new one). Terrible name that doesn't fit the title imo, but playing it felt similar to when I first played half life years ago, more than any other game I've played since then at least (except Half Life: Alyx).
I definitely think the atmosphere of Ravenholm contributed to my feelings about it, but I suspect if it was just the slow zombies or was all puzzles or something I would actually really enjoy it. There was something about the atmosphere + claustrophobic spaces + fast zombies in places I didn't like. Or rather, I did like it but not as much as the rest of it.