Harmony Remote
I got Harmony Remote last week and this is the best remote I ever had, it is Activity based, no codes to enter ( you configure it on the internet by brand and model and then download info to your remote trough USB cable).
It took some time to configure but it now controls everything, even my Prosonic DVD which was not in their database and I had to teach command from original remote. Once devices are added, you then program activities online, such as 'Wath the DVD' or 'Watch VOOM' or 'Listen to CD' and assign them to remote's hardware or lcd buttons. This basically same as macros in other remotes, but much easier to program and use.
It is ergonomic ( shaped as TiVo remotes), got an LCD and it is basically the best thing since sliced cheese ( or bread ). I did not read all the posts in this thread, so please forgive me if someone already mentioned this remote here.
Since the programing is internet-based , you can even play with your remote setting while you at work, then come back home, download new settings and see how it works.
It also downloads programm schedule for your favorite channels and shows it
on remote's LCD screen.