Saw (at least the first one) had some terrifying moments.Mulholland Drive for sure.
One of the creepiest:
The Others is another movie that isn't necessarily horrifying, but was very suspenseful and the writing was superb.