Sony RMVL600 (available on eBay and at Sony outlet stores for short money-$11.99 at the Sony store) will learn the DTA codes from the silly Comcast remote and can control up to 8 total devices. There may be other learning controls that can do this, but this is one of the least expensive around. I don't have satellite or TIVO so I don't know if it will control every possible combination of components out there. (But the keys are there.)
You do have to manually "learn" each number and some keys individually to be able to enter channel numbers directly from the Sony remote and to keep the Last Channel, Enter, Info, and to have full DVD/VHS functions. It is very easy. Just align the two remotes and match the keys from remote A to remote B.
It has macros to automate changing from one viewing setup to another. eg-With one button I can switch my TV to Video Input, change the amp to Video 1, start the DVD (or VHS) (with menu, FF, RW, etc. all functioning) and control the volume. Push another button and everything goes back to normal TV.
Teac AGV7700 receiver
Magnavox ZV427MG9 VHS/DVD-RW
RCA (17 years old!) 52" projection TV
Comcast Thomson DCI 1011 COM DTA
Enough has been said about the shortcomings of the "Comcast solution" for changeover to all digital and my setup is admittedly simple, but it works for me (and my wife could learn the controls in a few minutes)