While there were several creepy games prior to this, the first game that actually made me call a friend to come over for backup was Fatal Frame. Playing that game at home alone, at night, with a thunderstorm going on was most definitely a "what was THAT?" experience. Also the sound effects tend to build the creepiness as you play, and it never really lets go.