Undoubtably, there will be factors of CIV5 that are exploitable (whipping at certain times over others, pre-chopping forests, pre-building an oil well under a fortress in case the fortress is destroyed, etc.).
Ideally, and I don't know how to do this but would be interested to learn, once these exploits are known, they could be turned into the default action for one's workers, cities, etc.. Governor's suck because they don't learn. Automating workers is frustrating because they don't do what I want them to do. But if I could get a worker to perform how I want it to by pushing a single button or loading a mod, I would.
Better yet, the City Governors could watch me play a few games, get a feel for how I want a city run, and then do it. Then all I would have to do was double-check their work.
Take it a step further, I could then load my default actions up as a Computer Opponent and play against myself, trying to beat my own strategy.
Maybe pie in the sky for this release, but by CIV-X this is how we'll all be playing.