The horror drama marks the latest in a series of TV adaptations from the writer behind The Shining and Misery