I think the better analogy for Spidey is Roger Rabbit's Toontown Spin, for folks who've been to DL. Lots of sudden stops, turns, and spins but still a ride and not a virtual reality experience.
The ride I'd be concerned about for your son is the Simpsons. It's not a good ride for the motion sickness prone and definitely has its roots in Star Tours.
Speaking of which, I'm going to spend from now until our next trip figuring out how to enable DH to go on the Simpsons. He loves the Simpsons and would love the ride, but he's incredibly prone to motion sickness. If anyone has any successful remedies, please let me know.