Wow, lotsa love for the Harmony.
Just to throw out another option: Universal Remote Control (URC). IMO they are more professional quality products, but more $ and somewhat more difficult to set-up.
I also recommend the Harmony, although I do not have one. If they made an RF version of the Harmony One, I would get it. My new LCD plays games with the IR cable box for the first couple minutes after turning the TV on, so an RF option would make it perfect.
I also own an older Pronto touch screen. These are good remotes, but best left for professional set-up. If set up properly, they are awesome, but complex and pricey.