Hope they’re thinking more Civ V than Civ VI.
You can however hope that, just like with Civ1 (=> Civ2) => SMAC(X), someone will be inspired enough to take some of the best aspects of it in a somewhat different game :
Paradox decided to release CK3 on console, but it lags so far behind the PC version (which itself already lacks content) and I haven’t bothered to try it.
Now I hear that AoE2 is being ported to consoles and it just doesn’t make sense at all unless you’re planning on requiring the player to hook up a keyboard and mouse. I don’t see any way a controller can provide a good RTS experience.
I agree with you on the cartoonish leaders though.
Of course I like digging my own roads. I get to decide exactly where they go. That's the game.