Well, despite the low quality of the available movies on Netflix, we've been using it a lot. It helps that we've been on vacation and have had time to watch stuff, so I don't know that we'll actually pay for Netflix when the trial expires, but it's been fine so far. We have watched several mediocre chick flicks (The Proposal, Something about the Morgans, Victoria something or other), as well as the first 5 episodes of She-Ra.
I also still use the Revue for the web somewhat often, although it's as much for the novelty as anything else. Otherwise, besides Pandora there's not much there we've been doing with it. My initial recommendation is that it's not yet worth the price unless: you get it on sale, you use Netflix, you have a little money to burn, and you like cool gadgets like this.
The nice thing is that there is no subscription fee or any other cost for GoogleTV, so even if we don't use it much for a while I don't care since I won't be wasting money and can wait for more apps and features.