I've seen several children absolutely terrified before and after this ride, and heard screaming from all ages while on the ride. While it's not "scary" to me, it's hard to get me scared anywhere... but for the general population, I think it's at the right level.
However, I wish the land itself had some opt in scary areas. I would love an HHN style walk through / scare-zone attraction at Darkmoor. This would also be a cheaper way to alleviate concerns about the land being the smallest and give adults (and brave children) something a bit more intense.