I don't know how I feel about this. On the plus side I love the movie aesthetic and lore. On the downside TF3 was fairly terrible.
RotF gets a pass because most of that was written during the writers strike but TF3, while having a competent enough story (except really for that bit with the cosmonauts) was really poorly paced.
The first was good because the type of movie it was allowed it to build the pace slowly to a big climax/reveal at the end of the film, but by the second and third film its a given that the world knows about Transformers so they didn't really have to stay hidden for most of the first two acts.
On the plus side he got better at directing the Transformers action scenes as the movies went - by the third film he'd almost entirely dropped shaky cam in favour of fixed shots. So basically he needs a really good writer on board, and perhaps for Speilberg to crack the whip a bit.