I'm currently reading IT and I didn't think it was particularly scary, maybe because I know what it's about because it's just one of those stories you know without reading/seeing it - but when I walked over a bridge over a stream today and thought "ooooh, this would be exactly the place Pennywise would hide if he lived in this town..." So it must be scaring me somehow!
Of course, it could just be the memory of Cujo, which I remember as the single most terrifying thing I've ever read at the time.
Also, Mo Hayder's first two Caffrey novels, Birdman and The Treatment, but they're probably more violent than scary. Though The Treatment was set less than half a mile from where I lived at the time I read it, which really didn't help much.