I have a Revue purchased late last year for $99 and upgraded to 2.0. Here are my answers to some of the issues posted above.
1) CIFS/SMB easily supported using File Expert. Sees and opens the SMB shares on my Ubuntu media server just fine.
2) DLNA also works. The Logitech DLNA client works just fine with both MiniDLNA and Media Tomb. The limitation is the codecs supported by Android. If Android will play it you can get it via DLNA.
3) Plex is even easier. Set up a plex server, install plex on the Revue and, voila, streaming video. Plex promises that shortly (ha) it will overcome most codec limitations.
That said I don't want to watch Hulu or some of the other sites others are interested in. I want Amazon streaming video (well supported) and ESPN. Amazon is well supported and ESPN is reasonably will supported. The problem with ESPN is in Flash and, as I understand it, is partially a problem of Adobe, Google, ESPN and hardware. There are some glitches on all fronts, one of the most important is that when Flash sites are coded they make assumptions about the minimum level of hardware available on the client (memory, processor speed, storage) that the Revue does not meet.
So for me its a win. Amazon + 90% ESPN + excellent integration with my Dish box + full web browser + personal movies and photos. Your mileage may vary.