Ok, so I bought the game and gave it a go. I've traded it back in after a couple of days. The singleplayer campaign felt uninspired and bland. Multiplayer was better, but there are games out there which offer a far superior experience.
On the whole, I found it to be an adequate but thoroughly average and unremarkable game, whose only saving grace is the nostalgia many of us have for Transformers. Without the Transformers IP slapped on, I doubt this game would have garnered this much attention.
While I usually value Yahtzee for his humor, rather than his actual reviews, I can't help but agree with him. War for Cybertron is not a bad game, but in my opinion also undeserving of the praise it is getting.