The Harmony Remotes are, in my opinion, the best of a somewhat bad situation
Here's the thing: it's all about how you program the remote. It can be really quick and easy, but then kind of janky to use; or, it can be really pretty and user friendly, but then a pain in the rear to set up!
The best thing about the Harmony 900 is the button layout and the flexibility of the software. The worst thing about the Harmony 900 is the old interface, slowness, and complexity of the software. So the software is what makes you either love or hate a Harmony Remote.
Folks who only use the setup wizard will think Harmony remotes are easy to setup, but slow in sending commands, prone to errors, and lacking a clean and easy to use button layout. People who really dig into the software will find that with enough patience, a lot of trial and error, and some occassional creative thinking, you can get the Harmony Remotes to do just about anything you want! But it's a slow and painful process getting there because of the old, slow, clunky software.
So those are the complaints you're gonna read. People who either spend no time at all programming and wind up with a kinda lame experience, or people who took a deep dive, but had to hit their head against the wall for hours to get there!
The thing is, compared to all the alternatives, the Harmony Remotes are still the best. The "Activity"-based setup is so much better than an individual "Device"-based setup - even one with macros. And the software does contain an amazing and constantly updated database of IR commands for almost every device out there. It's certainly the easiest way to get all the "hidden" commands that your device understands, but the stock remote doesn't include! Things like discrete on and off commands instead of just a "power" toggle. And discrete input selection commands, or other menu or transport controls that aren't on the stock remote.
The hardware side of things is great. I think the 900 has a logical and comfortable hard button layout. And the touch screen - once you've properly programmed and organized it - is very useful. The wizard just sort of dumps any commands that don't easily map to the hard buttons on that touchscreen. So that's where the wizard really sucks. You end up with pages and pages of unnecessary, duplicate, and unorganized touch screen buttons! But slog through the software manually and that touchscreen can become very useful and pretty