This has been an interesting thread to read, though given it's length I definitely haven't read every single post. Personally, I have not bought Civ5 and definitely won't be doing so. I asked a friend of mine what she thought of the game and she essentially said what some others are echoing here, that there just isn't much, if any, complexity to the game.
This is really a shame, since the Civ series has always been about complex strategy. Even in Civ1, there was a good amount of strategizing you had to do to be successful. Of course, once you got the hang of things and learned the various peculiarities of the game things got a lot easier. Still, the core underlying principle remained the same: A complex, deep and rewarding turn based strategy game.
Unfortunately, it seems like Firaxis has succumbed to the temptation to dumb down your game to make it appeal to more people. Please note, I'm not bashing games that are simple, or somehow implying that people who like simpler games are 'inferior' or something. I love complex strategy games like Civ or EU3 (Europa Universalis III), but I also love games like Halo. They are different and good in their own right.
What's disappointing is to see a series like Civ which has been and was originally about complex strategy turn into a more simple game that, yes, is better suited for consoles. Really deep strategy games remain the domain of PC Gaming because it's just too hard or inefficient to control a bunch of elements on the screen with a gamepad. Imagine trying to play Starcraft II with an Xbox 360 controller. It would be brutal.
With all that being said, given Civ's past history and what people expect from the series, it's not surprising to see people upset with the new direction the series is going in. To put it another way, imagine if Halo:Reach departed drastically from the previous Halo titles, both in appearance and in function, such as Civ5 has done. There would be plenty of upset Halo fans, and rightfully so.