I recall people saying that DOW2 sucked.

It wasn't just here, a lot of people hate DOW2.
It wasn't a lot and it weren't normal people just uber DOW1 nerds that wanted the same game again.
RTS fans in general weren't keen on the changes made from what Ive seen. Said it was the beginning of the end for RTS games.
DOW2's problems are much more rooted in its overall execution (balance, usefulness of units, etc.) than they are in its idea that an RTS game can exist without a real economic model. Clearly COH was a great game despite it's lack of econ features.
RTS games are going to keep dancing around with the notion of robust macro and economic considerations, and RTS fans will keep on playing the games that still have active communities that do offer those features, and hope for new ones to come out that actually build off the successful base of RTS design than trying to rethink the wheel in a futile attempt to expand their audience.