I haven't seen it yet but I would like to.
I used to read all of the SK books and scare the poop out of myself until DH started working 3rd shift and I had to sleep alone at night. Now I just can't get myself to read them anymore. I was so tempted to buy this one the other day, though. Now I'm glad I didn't if it is really scary.
As far as Sk books to movies, there have been a few that I thought were done well. Shawshank Redemption, Stand By Me, and Pet Cemetary were great, imo.