I think he's made a promising enough start to his managerial career, but unfortunately, the stigma that was attached to him by too large a number of City fans whilst he was a player says to me that the conditions would be too difficult for him to be a success here.
Barnsley may be having a bit of a tough time (though I for one am a bit amazed that they stayed in the Championship for as long as they did), but it's a good sized club to be at, and if he can get them promoted in the next couple of years, that would give him an impressive achievement on his CV and I see that as more likely than him coming to us and successfully moving us up the table.