Y'know, Dale, I don't always agree with you, but there's nothing in your opening post I disagree with. 1 UPT and the switch to tactical vs. strategic (while still trying to be kinda strategic) was one of two things that ruined Civ5 for me, the other being global happiness, which I hear is less onerous with BNW. I'm still somewhat excited, since (a) the concept sounds good, (b) I'm not totally jaded about Civ5 since I only spent $7.50 on it and wasn't expecting it to be the bee's knees going in, and (c) I thought Civ4 sucked at launch, too, but by BTS it was actually pretty good, so it's possible that by Beyond Earth, the Civ5 base game will similarly have improved to the "good" category. But of all the news I've seen since the announcement, 1 UPT is the most disheartening. It would seem like a logical time to break with it since Beyond Earth isn't a Civ5 expansion.
Antilogic's posts have some good alternative ideas for limiting stacks of doom without killing the strategic nature of the game. And Blitzscream's right that if the Civ3 Army were re-introduced, being able to load/unload would be needed. I'm really hoping that with Civ6, Firaxis strikes a better balance to the stack of doom problem than the complete-opposite, with all its own flaws, 1 UPT system.
And yeah, a real Sim City 4 successor would be great. Sometime I have to get around to trying Cities XL - based on the reviews my expectations aren't great, but they're higher than my expectations for Sim City 5, even now that EA did get rid of the always-on DRM.
Oh, and VSorceress, Civ3 Complete goes on sale for $1.24 every couple months on Steam/Gamersgate, so if you're curious, it's pretty inexpensive to pick it up and try. Civ4 Complete tends to be a bit more expensive, but still not bad, occasionally hitting somewhere around $7.50. Next time Civ3 goes on sale for that price I plan to pick up a few copies to give away, so if you want on the list, send me a PM (I might not see a response in this thread).