The older Harmony remotes were fine. I wasn't a fan, but had many friends and customers that loved them.
The hub based remotes have been nothing but excellent for me. I had one die on me, but the other three have been going strong for almost a decade.
I've got backups for all of them if they die, so I should be covered as long as Logitech keeps up their end and doesn't kill their servers so we can program them.
Time will tell.