For Halloween Giggles
You can't go wrong with Mean Girls and Diary of a Wimpy Kid. The best part is that both films were adapted from books.
For Halloween Goosebumps
All containing Halloween Scenes, Hocus Pocus, E.T the Extraterrestrial and Idle Hands are fun to watch and not too gruesome. Although, I'd skip the latter for small children and replace it with Casper.
For Halloween Sweat
Halloween!! Had to go with a classic
Which Halloween themed movie tops your list?