I - usually - like how the governor assignes worked tiles based on the focus, but the choice of specialist citizens is often incredible dumb. Sometimes i highlite the automation button, to see what is suggested - check if i missed a good tile to work or something, then deactivate it again, even if i choose to keep the settings - you never know what idea might strike the gouvernor the very next turn.
Never automate citizens in your GP farm. One lausy turn running a Artist sitizen in your Great Library city might end giving you a GA instead of a GS at low odds... This is where i usually miss the "Shoot Governor" button.
I usually do not automate citizens in my first 4 - 5 cities - this many you can easily micromanage your self. When the empire grows bigger by conquest/expansion and also the population grows, the mm becomes tedious, and at the same time the relative value of many cities becomes less important... So i keep only a few primary specialized cities on manual, and let the rest be handled by automation.