My absolute favorite King adaptation was Misery. There are a few differences from the book but they are relatively minor and most of all the movie captured the heart of the story. The book was a bit more gory (like she chops off his entire foot, not just breaks his leg) but Kathy Bates was perfect in that role, and James Caan did a great job as well, and the script was perfect.
There was a made for TV version of the Shining which was closer to the book, but I actually like the Kubric version better even though it's significantly different. The TV version was just not scary, where the Kubric version scared the crap out of me, despite the differences.
I've always had an afinity for the Shining, I grew up in Colorado and have stayed at the Stanley hotel in Estes Park which the book was based on. The place is really not that scary in real life, so I'm not sure what his inspiration. The only thing I can think of is in the winter time there's hardly anyone there but the locals. Scariest thing you might run across is a mountain lion or a black bear.