Remember - the theme is Americana - a touch of old fashioned rural America and American superstition. Some of those suggestions really wouldn't cut it.

(Much as I like Fright Night....) Creep is better than gore.
For comedy I am adding VHS tapes for Cast a Deadly Spell and Witch Hunt. Neither appears to be available as DVDs. Also adding The Ghost & Mrs. Muir for comedy.
Something Wicked this Way Comes added to the children's room.
Children of the Corn... I have never seen. The story by Stephen King would pass muster, but some of the movies are based so very loosely (if at all) on his books.
Some that have failed: First, pretty much all the HPL -
The Dunwich Horror (1970)
The Dunwich Horror (2009)
The Resurrected (1992) Dear gods NO! It would be nice if anybody basing a movie on the works of H.P. Lovecraft ever freakin' read his stories!

The Haunted Palace Like The Resurrected it is based loosely on H. P. Lovecraft's Case of Charles Dexter Ward, and like The Resurrected it fails pretty much across the board.

Candyman Too much splatter, not enough development.
Can anyone recommend individual episodes of Tales from the Crypt?
And there is an old B&W movie about a ghost ship, set in New England, the title of which is escaping me, but images from which have stuck with me for thirty five years.... Then again, I saw it on a B&W TV, so it could have been in color. (Channel 38 in Boston, or was it 56?...)
The Auld Grump