As said above, everyone has to decide for themselves. Here's our story, though--
My DD4 was finally tall enough to ride. She had a "Future Rider" certificate from an earlier trip and was very excited to ride. She was terrified on Haunted Mansion, though. Therefore, DH and I were apprehensive about her response to all the preshow "stuff". We thought she would love the ride--she's not really scared of any rides. DH took her in with plans to cover her eyes and ears during the preshow. He asked her to start watching the movie and he would cover her eyes if she got scared. Well, when the movie was over and they were moving into the "basement" area, DD turned to him and said, "Daddy, when is the scary part?" GO FIGURE!!! After that, she loved the ride.
Just goes to show...YOU NEVER KNOW!
'