I must say I find this whole line of argument fairly pointless, amounting to argument for argument's sake.
You build or buy a builder. If you are able to, and choose to, automate it, it wanders off and plops down 3 improvements (presumably defaulting to whatever the UI would default to if you manually moved the builder to that tile and the improve tile screen popped up) and after 3, 6, 8 maybe 10 turns (taking into account travel time), the builder is gone. So you decide to splurge on builders -- you build or buy five (or ten) builders and automate them, and 3, 6, 8 or maybe 10 turns later, they are gone as well. In the meantime, for some inexplicable reason, your 6th city still has no improved tiles. Very satisfying.
I get that you might be annoyed by having to actually think about which tiles you want improved, much less direct your builders to those tiles and instruct them what to do, but I suspect that you're only going to have 1 or 2 builders who are "alive" at any given point in time. In Civ V, you might have 6, 8, 10 or more workers sitting around with nothing to do, costing you gpt maintenance, but you still need them to deal with city border expansion and to spam railroads late in the game. I may be wrong, but I don't see that as an issue in Civ VI.
Frankly, I would expect to see greater demand for automated warfare -- after you are DOWed by Japan, you pick 6 or 8 units and tell them "go kill Japan." The AI then does all the work of moving those units into position (called "tedious" by some), just like the AI does with its own units -- and then you can watch Japan kill your units one by one (just like you can do to the AI's units). Hmm, well, on reflection, maybe that would be a bad plan....
The fact is, the human player will always make better decisions than the AI. Some don't care about that -- just see the popularity of internet videos about AI-only death matches in observer mode. But it seems to me that, if you want to "play" a strategy game, part of "playing" the game is making many decisions, large and small, including decisions like, "Hmm, this builder has one more build action. Do I want another farm, or should he mine that hill, or improve that extra luxury?"
You might say, "I don't care about that decision. I find it annoying. I wish the game would just decide that for me." Fair enough, but others might say, "I find it confusing and annoying to have to decide what techs to research. Can't the game just decide that for me?". Others might say, "I find it annoying to have to decide what buildings to build, or what (and where) to place districts, or what military units to build, or when to upgrade them, or how my gold should be spent. Can't the game just do that for me?" And yet others might complain about diplomacy, or trading, or any other system in the game, and ask "Can't the game just do that for me?"
And the answer to all of that would be, well, the AI has been programmed to do all of that for itself, so in theory all of that could be ported over and automated for the human player. But if you did that, and players actually chose to automate everything, what's left of the game?