I don't even much care for horror games, but Silent Hills is still my answer. Just a crazy amount of talent attached to an extremely promising project.
Prey 2 also hurts so much. It was far enough along to have achievements made for it, which typically happens very late in development.
Prey 2 also hurts so much. It was far enough along to have achievements made for it, which typically happens very late in development.