Seems this year old thread got new life in it :P
But anyways, the scariest moment in a video game for me was in Batman: Arkum Asylum. Where you are on those floating panel things and had to keep an eye out for uh... dang forgot his name. The alligator guy. But yeah, that was freaky and...