The general performance of CIV is also ridiculously bad for what is basically a board game, especially in multiplayer, and at some point you just now what the AI will do. I still like the AI since they did a good job at giving the different leaders a personality within the rules of the game. But if you start for the 50th time next to Montezuma you know it might be a good idea to build some military. He will just never accept you.
Additionally the ability to stack units, while having problems of it own, made it a lot easier for the computer players to pose any serious tactical threat (without a gigantic technological advantage, a careful artillery and melee formation with a few healing units thrown in can destroy any computer-managed army of even ridiculous size; and the various "cheat" modifiers can magnify that to the point that independent city-states have been observed kicking the tar out of computer-player empires in both civ5 and 6 due to the regenerating free era-appropriate units that the tactical code simply can't out-maneuver)
Multiplayer in 4 tended to be all early rushes and road-ing/choke-ing (get some early unique units or archers to sit on key resources, stealing workers to build roads in between so your units could mass up to take cities faster). Back in the day I had a friend to play intentionally long games over weekends cooped up in the winter, those were immensely fun with a gentleperson's agreement to avoid direct conflict and try to win via tech/culture with maneuvering by proxy. The Civ4 AI personalities were much better suited to this as well.
Never tried MP in 6 but did some co-op in 5 that was reasonably fun, you really had to dedicate multiple evenings to it though so getting more than 3 people was impossible unless you were all sharing a dorm or something.
Overall the most fun multiplayer experience in a Civ-like game I've found was in Age of Wonders 3 as the games had a flatter tech ramp, tactical combat modes that took advantage of the hex map like war-games, and a RPG-light cast of semi-random hero generals to level up and give cute magic items to. Plus it had a variety of MP game modes for both competitive and co-op play.
This... doesn't seem quite that unrealistic compared to how states act in the real world!
[1] France wanted revenge since the Franco-Prussian wars, Germany wanted a repeat of the Franco-Prussian wars, Russia wanted revenge since its humiliation in a prior conflict (It was ready to go to war over another crisis in Serbia, but then backed down when it became clear that it would not win), and Austria-Hungary wanted to bring its unruly Balkan subjects under its heel.
Everyone involved was itching for a fight for decades.
[2] The British did not make it clear to the Germans that they would actually enter the war (Which probably would have dissuaded them from starting it.) The Germans gave the Austro-Hungarian empire a free hand in deciding German foreign policy. The Austro-Hungarian empire counted on the Germans bailing them out, and for a repeat of an earlier standoff with Russia. (Without taking into account that Russia, instead of standing alone, as it did in their previous conflict, picked up France and Britain as allies.)
All of this played out in slow motion, over the span of a few weeks, prior to the war beginning in earnest.
World War I, due to the prevalent myth of offense dominance that fueled the mobilization feedback loop that led to the war, is pretty much the exact opposite, so, yeah, it's pretty far off.
But basically the idea is that everyone knew a straight-up fight between major powers would be an ugly grind. But national armies take time to mobilize. So you want to mobilize early and try to win before everyone else catches up. This means that once it looks like things might kick off, everyone immediately goes all in. But if your sucker punch fails, buckle up for WWI.
https://emlia.org/pmwiki/pub/web/LeftBeyond.TalesFromTheBeyo...
[0] the mod grew too large for pure lua scripting long ago and the SDK was only released for windows. At least that is my understanding.
[1] current stable, there have been many beta releases since then: https://forums.civfanatics.com/threads/community-patch-how-t...
Civ 4 4ever
Many other games like Total War series or Age of Wonders dealt with the overall question by having split strategic and tactical game modes, and they're hardly alone in that. Civ5 and 6 tried to keep the bastard child of those two game concepts in the same strategic-map and it just doesn't work that well.
The corp/army mechanic could also be tied into that.
What I find most difficult about protecting your artillery in Civ 5 is attempting to siege cities with units that have a range of 2, because they'll be vulnerable to bombardment from the city no matter what.
But yeah, the artillery is more vulnerable in Civ 5. You can counteract some of that.
[0] https://civilization.fandom.com/wiki/Zone_of_control_(Civ5)
I'm really hoping that at some point a version of Civilization will come out with a more realistic AI (I haven't really looked into this but assume that a lot more is possible now than 10 years ago given all recent advancements). To me that felt like the main thing that caused me to lose interest at some point, interaction with AI players was too scripted and a harder difficulty level just meant more units and faster progression for AI players. I never got into multiplayer, I imagine it would be way too slow to keep my attention.