It's pretty good in a vacuum, but it don't think it's quite "one of the best horror games of all time"-tier, objectively speaking.
Maybe top 50 somewhere. There are just a ton of really great horror games.

Anyway, I guess I'm considered weird and prefer 3 aesthetic-wise, even if it's definitely the very weakest gameplay-wise.