The exercise isn't exactly scientific, but going for Transformers is where most of the other ads leveled out quickly, Transformers kept climbing becoming one of the few to touch the fourth row. I have a feeling that if the ad had started straight into Transformer action instead of human character reactions the ad might have taken the top spot.
Update: Other websites ran their own polls and what not to score the Superbowl trailers.
From Richard, MovieTickets.com poll had Transformers on top among the movie related trailers. 83% found the Transformers the most memorable and 23% said it encouraged them to see the movie this summer. The remaining top five was Star Trek (79%), Monsters vs. Aliens (78%), Fast and Furious (77%) and Land of the Lost (75%).
Bloomberg also did its own ranking of the commercials and the Superbowl. As far as ratings, the game had 95.4 million viewers and 42.1% of US homes with TVs making it the second most watch Superbowl ever (last years was #1). According to Tivo, Transformers Revenge of the FAllen trailer was the fifth most watched commercial of the night, "was the first movie trailer to reach top 10 since 2003." Overall, considering the instant awareness the trailer clearly brought to the movie, I am thinking Paramount is pleased with the results of that $3 million commerical. Thanks to Chris for the link.