I got my Logitech Revue on Friday, and have had a day to play with it. It is clearly a work in progress, which will be accelerated greatly when the SDK drops for it early next year. The long review of the device will come later. There are some really neat hints of where this is headed though, best exemplified with this screen shot:
That is a search for House looking at the Series results. You are looking at Season 7 results (including items in the future) and next to each episode is whether the episode is available on your TV (i.e. DVR), the Web, of Paid (which currently corresponds to Netflix or Amazon on Demand).
Once you can hook into the content providers interface with the SDK, this becomes really interesting.