As was mentioned it depends on what you define as "scary." We went on it last summer and DH and DS(11) and DS(14) LOVED it and thought it was one of the best rides they ever went on. They ended up using single rider to go multiple times.
DD(7) didn't like it, but she was OK. I have a feeling that she will end up liking it when she is a little older.
My experience was completely different. I am fine with coasters and motion simulators and the like, but hate things that jump out at me. (I avoid Dinosaur at WDW.) I also hate spiders. The combination was just too much for me and even though my eyes ended up closed for about 3/4 of the ride and I did my best to block out all sound, I was terrified! I actually ended up bursting into tears when the ride was over. I haven't cried over a ride since I was a kid!