The diversity of opinion is great... while I am concerned that Civ becomes "Panzer General throughout the ages", I would hope that the spirit of the game is retained... also, as a SMAC veteran, I do miss the Economic victory option (becoming that all encompassing World Bank, all New World Order style... ;-)
Still, if I want a "realistic" war experience, I whip out Total War... Civ has always been "strategic" level and never at the "operational" or "tactical" level... having said that, I have never really encountered the Stack of Doom issue that everyone keeps mentioning... I'm more of a "Blitzkrieg" player (Napoleon shocked the socks off traditional Europeans that way!), so it's about rapid incursions with several groups, which seems to prevent the opponent from pooling their units, as they instead disperse to respond to the threat... so, I have never perceived the need for a SoD fix, naturally...
On some level, I am vexed by the whole idea that, in a hex that takes forty years to traverse, I have only one "unit" (ten axemen? fifty? ten thousand?) so if they are going that way, then why not just make units "armies" with mixed forces, and the AI can calculate the effect of your technology on the army's performance? Just a thought...