I doubt changing to more than one unit per tile is going to happen with this edition of the Civilization series. Maybe some future edition.
The easiest and most obvious solution to solving this edition's biggest problem - that the AI can't compete with the human player in combat as it can at other aspects of the game - is to boost AI Combat Strength.
The day that an AI civ can tactically compete on equal terms with a human player is probably a long, long time away. So that means, if one wants to make the AI more challenging in war to a human player, one must boost either its quantity or quantity (or both together). If going for quantity, then one is going to have to give the AI probably five or ten times as many units as an experienced human player for it to win in a war. I don't mind the AI having a few extra units, but huge hordes of mindless AI units would feel more like a zombie survival game than a game of civilizations.
By improving AI's quality through increased Combat Strength, one can, in theory, play with equal army size to the AI. That is a much better and more immersive solution, in my opinion.
It would probably take just a few lines of code to make it possible. I'm not a programmer, but my uneducated guesstimate is that it would probably take less than ten minutes to do.
I'm not that bothered whether this is integrated into the official game - no-one has to play with a non-incompetent AI - but I am bothered that this can't be modded. They half-allowed it, so one could get a tantalizing glimpse of how much better it made the game, but did not allow it to be fully used, thus horrendously unbalancing the game by not letting city-state units get any Combat Strength along with the AI civs.
To be honest, it's made me lose the will to play the game anymore. I'd be reminded of it every time I mowed down a dozen AI units like daisies, without the loss of any of my own units. It would make me think of all the epic wars I could be having with the AI in some alternate reality.