I first read Stephen King books back in the '70s (Salem's Lot, Carrie, etc.). I find I like some of his books/stories and of course, others I don't. IMO, Pet Sematary and some others had parts that were way drawn out and became maddeningly repetitive. Others, especially It, I think are absolute classics. I also enjoyed The Talisman which he co-wrote with Peter Straub, buy not so much Black House. I liked Desperation but not its opposite, The Regulators. I was surprised that I liked Rose Madder and Insomnia.
My favorite screen adaptation of a Stephen King story is the original Carrie, directed by Brian DePalma. I don't know if I've seen another horror film where the characterizations were so well-done, or the actors/actresses were so right for the characters. IMO that is one screen adaptation that definitely was superior to the book, and remains one of my fave movies.
The horror-type novels that have impressed me the most are written by Dan Simmons. Carrion Comfort is my top pick, but Summer of Night is another classic. Actually, anything Simmons writes is pretty much at or near the top of the heap; crime stories, sci-fi, intrigue, horror, action, etc.
As far as creepiness in horror writing, I thought Peter Straub was top-notch early on, but not more recently. Clive Barker is okay, I liked Coldheart Canyon. Bentley Little, IMO, has some books out that may have the highest creep factor, esp. University, The Ignored, The House, The Store, and Dominion. But some of Little's books after a while seem like the same plot in different settings (a small community gradually taken over by the most perverse evil).
Some of Stephen King's short stories can be sorta funny. One of them in Everything's Eventual had me laughing inappropriately, don't remember which one, but it had a guy going nuts in a restaurant with a knife and stabbing a lawyer(?) and the lawyer says "bloop" or something.
Jim