I don't remember much about Stand By Me either but I do remember Maximum Overdrive being pretty bad. You seriously think it's the best of all the King adaptations? Yikes.
I really need to watch it again but I'll believe you . Although 5.5 on IMDb and 17% on RT doesn't give me huge confidence that it's any better than or as good as Carrie, The Shining or The Dead Zone.