I'll tell you the first game to really give me nightmares: Clock Tower The First Fear
That was about early 2000s. Anyone who doesn't find this gem frightening is lying!
It's strange, I remember reading about it when it was still new and it sounded horrifying. I watched a friend play it a few weeks later and I found it less horrifying and more amusing, although I can't remember specifically why.