I'm an avid coaster fan, having ridden coasters around the U.S. and other attractions such as the 162-ft drop via bungee cord at Carowinds. Here's how I rate the rides at WDW:
#1:
RnRC - fastest, most thrilling of all the coasters. 0-60 in under 4 seconds then it goes right into two separate 360-degree loops. My fave.
#2:
EE - tough call between this and T
oT, but it gets the nod due to the backward plummet. I don't find it particularly scary in any respect, but the Yeti near the end (even if you can't see it, there is virtual darkness for a couple of seconds and the loud roar of the Yeti which you can't miss) might upset those who felt A Bug's Life was too scary.
#3:
ToT - love the unknown aspect since each ride is a little different. The queue might be unsettling to little kids, and the Twilight Zone music in the near dark on the trip down to the chute still makes me tingle (I watched TZ as a kid), but the ride itself is a hoot and since nothing jumps out at you makes it less threatening.
#4:
Test Track - though a very non-scary ride and mostly a benevolent one, I love the acceleration around the track after you get outside. Nothing like doing 60 mph with the wind blowing through your hair!
#5: All the rest: None of the others stand out much to me as being terribly scary or particularly thrilling.
Space Mtn is far bumpier to me than TMR, and the seating on the former hurts my back.
Splash Mtn is pretty cool, only the seats and cushions have a very sour, sweaty smell to them from years of dampness. I tend to avoid that ride anymore. Smaller kids would enjoy the new Ariel ride in New Fantasyland.
Star Tours is a real hoot with the new 3D addition and not scary at all, just bumpy. Finally, in one cautionary tale, I wouldn't recommend the Dinosaur ride in AK as the animatronic dinos in that one tend to scare people as a couple of them come right at you. My 12-yr old daughter had the bejeebers scared out of her a few years back and still won't go on it!