The water monster in Amnesia the Dark Descent. Hell that entire game drove me to the brink of insanity.
The other scariest moment that comes to mind is that room with the giant mirror in Silent Hill 3 scared the hell out of me because I had no idea what was going on and it was just really really disturbing looking.