I think that's the crux of the issue right there. A lot of people feel that micromanagement is a fun, challenging aspect of Civ that deepens the experience - and that if you have to micromanage a lot, you're a good player. Some of those people appear to miss that experience in Civ V.
A lot of other people don't want to micromanage at all, and feel that it is boring or meaningless, only challenging by being tedious, and don't see a correlation between skill and willingness to endure boredom.

Some of those players appear to enjoy the fact that Civ V doesn't require so much micromanagement.
There's no right or wrong here; it just comes down to personal preference. I myself obviously fall into the latter category - micromanagement to me is the equivalent of watching paint dry.
Can I do it? Sure... just like I CAN sit still for hours and watch paint dry. Do I want to spend my free time that way? Do I think my ability to sit and watch paint dry for hours makes me especially intelligent or capable?
Hell no.