Cliche as it may be, off the top of my head I immediately think of Silent Hill 2. One of the most unsettling experiences I've ever had gaming. Anyone who's played it will probably agree.