I went with a few friends last September and last December, and none of us are thrill ride people at all, but we all have our individual preferences and quirks. There is my one friend who won't even go on Pirates. She used to ride both Pirates and Star Tours years ago, but no more. She won't ride Soarin' Over California either. No Splash Mountain (too big of a drop). She WILL ride the Teacups and she WILL ride Roger Rabbit's Car Toon Spin. She was bored with both the Nemo Sub and Jungle Cruise and mildly amused at the Holiday Small World ride. She most enjoyed the Haunted Mansion - NBC holiday overlay. Then, another friend will no longer ride Star Tours (even though she used to), but she liked Soarin' quite a bit and she LOVES Pirates, and she is okay with Roger Rabbit. Then, my third friend is a bit more daring and will ride Splash Mountain and Big Thunder, and she LOVES Soarin', Indiana Jones and Pirates, but will NOT ride the Teacups or anything that spins, nor will she ride Star Tours. And I basically stay off most of the 'Mountain' rides, but I LOVE Star Tours (I am the only one left who does!), I LOVE Pirates, I love Roger Rabbit and I am sort of okay with Soarin' and the Teacups. If I force myself, I can make it on to Indy, but I am very nervous about it! So basically, my point is, everyone seems to have their likes and dislikes, but there are always plenty of options for anyone of any age, size, preference, thrill ride expertise. You will have a great time!
Oh and by the way, you can sort of control your spinning on Roger Rabbit. It will spin anyway, but at a slower speed than if you spin the car yourself. And Buzz Lightyear spins if you make it spin, but not otherwise, and it is a slow ride!
And none of us will even go near Twilight Zone Tower of Terror! NO WAY!