What I want (for Civ 5; I don’t care about Civ 7) is a semi-auto explore: let me tell the explorer the rough area I want it to explore, then ask me again once it’s done. It’s enough to reduce micromanagement, but it allows me to set up my priorities, that might be different from one playthrough to another.