I used to be a ride chicken & still cannot do spinners like the Teacups - I love Teamboat Springs. My DH who doesn't like drops like Splash Mountain, also loves Teamboat . IT's a good ride, a little thrilling, but not in a roller coaster way.
I say give it a try. If I remember correctly, there is a spot on the way up where you can see it in action.
I am also prone to motion sickness & had no problems with this at all.