CNET calls the Logitech Harmony One "arguably the best consumer remote control currently available," and I agree. I've owned one for nearly two years, and it's without a doubt my favorite remote ever.
Alas, Logitech still sells it for $249, same as when it debuted in early 2008. But if you're willing to go the refurb route, you can get the Harmony One for $149.99 shipped from CompUSA.
For those not familiar with the Harmony line, its claim to fame is a simple, Web-based interface for setting up your devices, programming "activities" (a.k.a. macros), and so on.
This particular model features a color touch screen, a perfect button layout, and a docking station for keeping its rechargeable battery topped off.
Amazon buyers rated it 4.5 stars. Needless to say, it's a winner.(and the above video) should tell you everything you need to know about the Harmony One. For what it's worth, a handful of CompUSA customers rated it 5 stars on average, while some 800
Because it's a refurb, the warranty expires after 90 days. I have no problem with that; usually, a product like this either works or it doesn't. My 2-year-old One has been dropped, kicked, abused by children, and more, and it's still plugging along just fine.
Thus, if you're in the market for the ultimate universal remote, this is the best deal I've seen yet. (If you know of a better one, be sure to mention it in the comments!)