Silent Hill 2 is full of incredible atmosphere. Gameplay is not stellar, but it is a product of its time I suppose?
But the character development is incredible, and the dog ending is canon no matter what anyone else says.