I rode it for the first time a few weeks ago and felt very much like the OP. I think the Spiderman ride is one of the best rides in the world, and I don't even know or care that much about Spiderman (have only seen two of the films). I went into Transformers expecting something similar and walked away kind of underwhelmed. I don't know much about Transformers, but the ride seemed confusing and I had a hard time getting my head into the story of what was going on. As a result the ride just seemed very... loud?... and just very visually overwhelming, in not necessarily a good way. I feel like it needed better pacing, more room to breathe, and less sensory and information overload. Spiderman seemed in general a more elegant ride experience, with a better soundtrack and cinematic feel.