That depends entirely up to you.
HHN has dim lights, fog, and scary people roaming streets trying to make you scream. There are haunted houses, some of which are gory, where there are scary people trying to make you scream as well.
There are guys with chainsaws (no saw, but plenty of noise), creatures with trashcan lids, etc.
HHN is fun as long as you allow yourself to get scared and laugh about it later. The scareactors won't touch you, won't hurt you, and won't chase you....far. They also won't bother you for very long. Just a few seconds at most.