RE: Planning a trip for September 12-14th- Howl O Scream
As far as content in the park, at night certain areas can be intense and I would be especially leery of staying late for older folks with faint hearts. If the park does anything like last year the "scary" areas should be broken up into different isolated hamlets throughout the park, but keep in mind that means nightmarishly-dressed scare actors are creeping up behind you and startling you. Couple that with loud noises and a tense environment and you have a recipe for nightmares for younger ones and possible medical concerns for older folks.
Some areas of the park (historically, Killarney and Oktoberfest in particular) have more of a "Halloween party" atmosphere and have nothing more than decorations, classic rock music, and bars. Some areas play gloomy, eerie, or intense music but have nothing more than dense fog and decorations- nothing popping and startling you (in 2013, this included the Wild Reserve, Heatherdowns/Scotland, and Festa Italia). But Aquitaine, Rhinefeld, San Marco, and Banbury Cross all had scare actors and intense scares.
People will say that the park's scares are weak, and indeed they are less intense lately than they have been in past years, but they can still give you a good scare or plain-out startle you. I scare somewhat easily and the tense atmosphere keeps me on my toes, as undead monsters and bloody murderers get up all in my face. Again, this could really startle a younger or older person. Imagine hiding and jumping out at your grandmother yelling "BOO!" times maybe three or four. If you think she could handle that times three or four, she should be okay, but still be cautious. Children vary greatly in how they handle things. If a ghost story is enough to keep your ten year old up at night, then HOS won't be fun for you!
By warned that A.) It's essentially impossible to make a loop around the park without encountering at least one of the scare zones, and B.) Ripper Row, one of the more intense scare zones, takes place in Banbury Cross so you are forced to go through that area and its scares when exiting the park. If you stay at the park past 6 when the scares open, be forewarned that you'll be forced to go through Ripper Row even if you wish to a void the scares.
As someone who gets startles easily, for me part of the fun of HOS is seeing the park decked out for Halloween during the day. The park always looks great when the creepy decorations idly
compliment (not
replace) the park's landscaping. Also, last year I thought all of the shows were amazing. One of them, Dig It Up (music show) is rumored to be gone for 2014, and if that's true that's a shame. But still, be sure to check out all of the HOS shows during the day- you'll regret it if you don't. Night Beats in the Festhaus is one of the best HOS shows in the park's history. I personally like Fiends in the Abbeystone Theatre, but be warned of the "naughty nurses" which give the show a rather adult theme. A lot of the adult jokes may go right over your ten-year-old's head, and I see young ones watching Fiends all the time, but be warned that it may be offensive to younger ones or older folks.
My grandparents (now in their 80's) visited HOS three years ago and loved it. They enjoyed the shows and the scenery during the day. At night we continued to just enjoy the park like normal, because back then the park had smaller scare zones instead of hamlet-wide scary areas, so the scares could easily be bypassed. When a scare zone couldn't be passed, we quickly walked through it. Most of the time, the scare actors were observant and respectful of my grandparents being older, and rather than trying to scare the crap out of them, simply played with them and teased them a bit (my grandfather loved it when the puppetmaster clown came up to him and had the puppet climb on him). It was good. Whilst I was riding Griffon, though, my grandparents unknowingly wandered into Catacombs and within the first thirty seconds of entering realized their mistake and had to be escorted out of the maze by security. So yeah.
Oh, and as far as hotels go, I'm not very familiar with that, but I do see various hotel shuttles pulling into the park frequently. Any major hotel would likely offer shuttle service to the park.
Whelp, I hope that helps!
tl;dr Everyone takes scares differently, but be cautious with younger and older folks. Sometimes just HOS during the day is enough, but if they're good with the scares, then have at it!