I'm a big SK book fan, I've read loads of his stuff but I think I speak for many fans when I say his good books often get turned into crappy movies.
The best film based on a SK book has to be The Shining. I enjoyed IT but it was made as a TV series then pieced together for a film, thats why there's silly "cliffhanger" moments every time the episode would end. 🙄
My fave SK novels are The Dark Half, Desperation (see my location!) and Bag of Bones. The movie they made of The Dark Half was truly awful, read the book and see why it is one of a lot of SK fans fave book. 😉