I applaud the changes made in Civ5 combat from the super stacks in Civ3 and Civ4, but in the end it's still inherently flawed and completely unrealistic. War is not fought as 1v1 duels between units stretched over thousands of miles of terrain (if you think of each hex as hundreds of miles). Ever since the massive armies fielded in Ancient China and Mesopotamia, war has been about combined arms and tactical maneuvering. Civ5 once again fails to capture this accurately.
In my opinion, combat was the closest to reality in the Civilization-clone Call to Power II, where units fought in armies. Even though the player could not control the action, the fighting was remarkably intelligent: spearmen and other melee units would form the first ranks and clash with the enemy. Archers form up behind them, providing support fire, while knights and other mounted cavalry attacked from the flanks. Dale's Combat Mod for Civ4 used similar mechanics.
Oh and before people say "it's just a game" in response to how unrealistic Civ5 combat is, keep in mind this game strives to be a historical simulator of sorts, so realism should be high on the priority list.
In my opinion, combat was the closest to reality in the Civilization-clone Call to Power II, where units fought in armies. Even though the player could not control the action, the fighting was remarkably intelligent: spearmen and other melee units would form the first ranks and clash with the enemy. Archers form up behind them, providing support fire, while knights and other mounted cavalry attacked from the flanks. Dale's Combat Mod for Civ4 used similar mechanics.
Oh and before people say "it's just a game" in response to how unrealistic Civ5 combat is, keep in mind this game strives to be a historical simulator of sorts, so realism should be high on the priority list.