That internet connection requirement gets you the largest database of remote control presets out there and more importantly everything added in the future. It also expands the database as YOU program custom buttons and functions.
If you can find another remote that you can buy today and know you'll be able to program it for your next set of not yet on the market devices, and the set after that, etc does IR and RF, and can mix and match device buttons and functions without switching button profiles, and still does let you program custom functions like a 3D button, subtitle button, VIA button, DVR button, TV Input, Setup, Menu, etc, etc, etc. And actually manages to provide a better interface at a reasonable price point. I'd love to know.
But thus far, the logitech harmony series is the only thing I've found that actually gets that job done at all and therefore is the best by default.
Agreed. I'd prefer the option for an offline interface, but their remotes are undeniably the best out there.
My only complaint is how newer models of devices at the same price point now support FEWER devices/activities than the older remotes. Memory only gets cheaper over time, and limiting the number of devices per remote is just a greedy way of forcing users to buy more remotes. (I have an older Harmony 520 that supports 12 devices, whereas the newer Harmony's in the same price range only support 8).