I don't usually automate workers. There are two circumstances where I do. Near the end of the game, when enemy spies are sabotaging resources, I will set some workers to trade network automation in case I miss some of the messages about sabotage. Sometimes I set workers to full automate in colonies, if I am planning on granting independence.