Fatal Frame is no contest being the scariest game in consoles
Other scary console games will be the Silent Hill series lor... and not to forget the Resident Evil 4, really almost pee in my pant when 1st encounter the chainsaw maniac.

for PC, don't forget the 1st Alone in the Dark, last time running on my 386 with internal speaker still scare the shit outta me... "THENG!!!"

Another one from the PC is Undying, the scariest FPS I ever play after System Shock 2.