Some ways to alleviate the micromanagement associated with the constant need for upgrades would be:
1. Upgrade ALL units of a given type to another given type.
2. Upgrade all units *within a given city* from a given type to a given type.
3. For ALL units that have a certain weapon, upgrade that weapon to another (more advanced) weapon (bronze swords/shields to iron swords/shields, for example).
4. For ALL units that wielding a certain weapon, add an additional weapon (like the pilum (the short throwing spear) of the Roman legionaries).
5. After you research some weapon, the game may ask you whether you want to redesign some unit(s) and would automatically take you to the Unit Design screen, if you choose to do so. And after you finish a design you may immediately order an automatic upgrade.
And, yes, there don't have to be hundreds of weapons (especially in the early ages). Swords, bows/slings, body armor, shields, bronze/iron (and the associated metalworking crafts), some special techniques (civ-dependent?) for edged weapons or spears/arrows, and the like would be enough for the foot soldiers, for example. That won't increase micro-management all that much.
There may be military sciences focusing on tactics, logistics, training. That would allow advanced army formations with attack/defense bonuses (i.e. pike wall - with shields that would become a phalanx; tortoise; etc.), supply lines (bigger armies operating deeper in enemy territory), more disciplined troops with higher morale, etc. But I'm not saying that all this should necessarily go into the game, neither am I suggesting that my ideas represent the ultimate wisdom in the Universe. Things should be thought out well. I just like more flexibility in my wars. Not just stacks of 20+ swordsmen which rely almost entirely on a random number generator.
Having the stacks of units grouped into armies would be great IMHO. And I definitely believe that armies should be upgradeable and it should be possible to remove units from an army and add other units into an army (as well as disbanding an army back into its individual units). What good is an army consisting of spearmen when there's infantry available? Why shouldn't we be allowed to upgrade an army? And why should we need a Great Leader to create the army? I will point out again that Great Leaders can improve an army but they should not be mandatory for its creation. After all, we know of many Bad (i.e.
not Great) Leaders who lead armies and failed.
Also, I don't remember having problems with any game which offered me tactical battles. But that's me. There will be others out there who cannot stand tactical combat and prefer the current number crunching. And perhaps they won't like even the
option of tactical combat, even if it can be turned off. Who knows. The battles don't have to be Shogun-Total-War-like. While I enjoyed Shogun & Medieval very much, I'm not pressing for a super realistic combat simulator. Some system like Heroes of Might and Magic 4 (without the magic
) would be sufficient.
It's a valid point, though, that it will take some effort to write a good AI which would create good armies. But is that so difficult compared to an AI that must formulate a global strategy? I believe a strategic AI is even more difficult to make than a tactical AI. And we already have a strategic AI, although admittedly not a superb one. If they really focus on AI for Civ4, they may hit the mark. I believe AI should be a top priority.
(By the way, I should be allowed to enter tiles occupied by my allies. Either to protect the allies, or simply to work the tile or pass by. I cannot stand it when an ally who has Right Of Passage steps and stops on my ONLY road to a given city, for example, and I have to waste whole turns to go around his units. In the case when I'm occupying a tile together with an ally and the tile gets attacked, it would be nice if my ally's units and my units get into the battle together, although his units may have to move automatically without me having control over them.)