Jane, the original The Omen still gives me the creeps, have to agree on that one.
The only movie that has really scared me since I've been a grown up (chronologically anyway) is The Ring. And it really scared me.
My wife just watched Constantine with me last week. I have it permanently on my computer with 10 other movies that are my all time faves. She thought it was very scary. I've seen it a dozen times now, never thought of it as scary, just really great.