I'll agree that EA did a terrible job of explaining to people why the new game was different than the old ones (i.e. why it might require always-online). I think the key point comes from this (taken from the OP):
> Players who want to reach the peak of each specialization can count on surrounding cities to provide services or resources, even workers. As other players build, your city can draw on their resources.
What some people may not realize is that the cities in this new game are pitifully small (probably so that a computer can handle trying to update 20k sims at a time), so in order to actually do anything of significance, you usually have to draw from surrounding cities for materials, people, etc. This is the part of the game that requires online-only, because unless you want to be simulating all of the cities in your region (which I'm assuming you don't, but I don't really know whether the computation costs would be that high), you need some sort of server to handle that for you.
People claim that they came out with an "offline patch" that allows you to play offline, and while that is true, you then miss out on all the city-sharing features, and thus your cities end up crappy, because it is impossible to manage all the resources within a single city.
I'm not saying that what EA/Maxis is doing is necessary, but people seem to be missing that this is the main reason that the cities are always online, not just for the city saving features or anything.
Also, I do know about the StarCraft to StarCraft 2 drama, and from what I can tell, people don't really care any more, and people have gotten over the fact that they need internet to play their game. Sure, sometimes the internet drops in the middle of a tournament, and people get riled up about it again, but it seems to have died down very much since the launch.