The Harmony has both it's detractors and it's fans. My neighbor just got it not to long ago and seems to love it just fine. He doesn't have a very complicated setup at all however. He just uses it to switch inputs on his TV and control his DVD player, though I don't see how that would make that much difference.
I think the biggest gripe is it has no RF capabilities. For my setup where I have all my equipment in a cabinet, this is a bigger issue. The IR just doesn't work well and some of the delay times I would need would make it a pain in the butt to just sit there holding the remote pointed at the system while the macros run.
At least in my situation, RF is where it's at and I've gotten that from the folks here who' likely forgotten more about this stuff then I'll ever know.