Silent Hill 2 is widely considered one of the best horror games of all time. Whenever there is a list about the scariest games of all time, Silent Hill 2 is almost always near the top of the list or at the top.
Source: N4G PC 'Silent Hill 2': The Epitome of Psychological Survival Horror and Emotional Depth