I do not get motion sickness, but these are my observations:
If "spinning" is an issue with you I would have to say you should be more concerned with Men in Black. However, the spinning motion is a lot more slower than it has been in the past. You can always try to close your eyes, as others previously stated, but for some it works, some it doesn't. Some take certain things before going on certain simulators. I cannot recall what people take, or do before, so if anyone has any suggestions I'm sure they'll let you know.
Between Spiderman and Transformers, Spiderman spins more (still not much). Technically the only full 360 I remember in Transformers, was divided up by stopping in the middle of it. Unless there's another I do not recall. For the most part the rides itself technically is not spinning, but turning partially to one side, or another and moving towards a direction, sometimes turning behind, but not a full 360. Either way, due to it being just a video and it's fast pace, makes it appear as if it's turning around repeatedly.
In general roughness (not spinning), out of all the simulators The Simpsons is the worse in terms of that. It was a fun ride when it first came out, with it's new screen and it's animation, but unless you're in the front row it's not worth much, since if you're in the back everyone's heads will be blocking the view and you're going to feel even more tossed around in the back.
That being said, the only tip I can give you to not feel so much motion (on any simulator) is ask to be seated in the front row while also stating that you're willing to wait for the next ride vehicle in order to due so. However you cannot technically request this on The Simpsons, as once everyone gets into the ride vehicle area it's whoever gets to the room first, who gets to choose first where to sit.