I don't have a Revue, but I really like my Sony Google TV. It's the best television I have ever owned. It was probably a mistake releasing it without finishing the SDK / App feature (which they just released a few weeks ago, almost a year after the launch).
I'll second this. Google TV was a must for me because it drastically reduces the interaction I have with the abysmal set-top UIs (first Comcast, now Dish). I briefly considered the Revue but passed, mainly because I don't want to replace my remote with huge keyboard + trackpad -- on that basis alone one could have predicted the failure of the Revue.
Who could seriously pitch a general consumer device which requires you to replace your remote with a full-sized keyboard?
I have a Boxee Box as well, but Google TV and Boxee occupy distinct (if somewhat overlapping) niches. I use Boxee primarily to playback media on my network -- Boxee's UI is horrible for playing back web content, it frequently fails either/both to get the content or to enlarge it to full screen. But for presenting an organized view of your library and playing back a file on the network it's perfect.
Google TV, on the other hand, handles Youtube and other web-based sources of video very well. And as of the new update, it does a really good job of presenting you with a comprehensive view of what's on TV. Not like the stale program guide that all STBs have -- it actually segregates currently playing shows and movies into genres. Supposedly it will be able to make recommendations too.
TL;DR -- I'm not at all dissatisfied with my Google TV.
