As boring as the first movie version and the book
Not much else to say. As stories go, there's nothing really scary or original about this one... whether you're talking about the movies or the book. Not sure why Stephen King considers this his scariest work.
The only way they could have made it memorable was through the directing. Both movie version suffer from bland directing and some cheesy special effects.