The mirror room in the hospital of SH3 is probably at the top of my list of gaming moments that terrified me. It severely creeped me out (I was like 13). *shudders*
And in Silent hill 1 that scene when some messed up thing breaks through the window of the bar.
Still remember it to this day.