I'm sorry, but it just isn't. I did it twice last season, before and during the Halloween takeover, and it just doesn't really compare. The story isn't as engaging and the immersion isn't there. The effects within the actual ride are laughable and the sound system is poor, you can hear the system operating. It doesn't come across as awe inspiring, or magical, but I wonder if the size of the ride (compared to Hex) is also a factor here.
The only thing The Haunting has going for it are the effects in the second staging room, before you enter the ride. The first time I did it, before The Halloween takeover, I genuinely had a few jump scares and was impressed. These were seemingly not working during Halloween though, and the altered story line (the original) was a bit dated.