Maybe we could just have civs put a greater emphasis on mana over food/production/commerce. Like if a civ is set to favour a certain mana type, they put a rating on that mana type to be valued to 200 food/production/commerce. Workers then would never automate the mana away. I suppose you would have an issue with the city always wanting to work that tile though.. but I think it's a smaller price to pay.