The servers had DRM problems but that wasn't the only issue. I thought this was widely known, but maybe not. Much of the simulation (percentage unknown) was done on the servers. A bunch of, most likely, Java code that ran on the servers so the various player cities could connect to each other. When the brown stuff hit the swirling dispenser somebody realized they needed to fix it. Six months later (-ish, I never got the game) they had an update that moved the simulation off their servers. I did read a blog regarding the situation.
So two things were coming at them in swarms they didn't plan on. First, the DRM and in typical EA fashion they completely bungled it. Not only did their CEO proudly pronounce his supreme idiocy but he enforced the same in that he only green-lit multi-player games. Luckily he is gone, sadly I anticipate Project $10 to arrive at Unity soon.
The second was typical server mismanagement at AAA game companies. It all sounds great if you plan on using Vendor X server and Vendor Y Java implementation with M many servers ready to go with N network connections. But seriously AAA game companies cannot do the math to get the right setup nor will they ever spend the effort (resources, cash, infrastructure, QA) necessary to simulate 200,000 players logging on in the same exact time window. Why wouldn't they? Pre-installed games only escalate the problem.
Now, note that many companies have the first day blues on their servers. One special event in my memory was watching apple not being able to handle the load on a Xmas evening. Everybody had their new iWhatever, had their shiny iTunes Xmas gift cards in their hands and - boom - server overload.
The link to the bad path finding is hilarious so thank you very much for that. I might have to look into getting it when Origin does a cheap deal for it. Just so I can set up failure modes.
Well stated, Shamus. With the caveat that the princes screwing the pooch might have been made clearer earlier versus the team - you did cover it at the end. That is most likely just me disliking EA management to the extent that I do.