In a nut shell, Spiderman is just a much more enjoyable experience. Transformers felt too full on and 'in your face' as such. It made me feel a bit dicky too.
With Spiderman, it's the scene where you're lifted to the top of the buildings that does it for me. When I first went on it, jeez that...