I think boxee may just the best solution out there right now - it seems they've hit a sweet spot between the cheap-but-simplistic appleTV and the expensive-and-ambitious-but-half-baked Google TV.
Don't discount Plex http://plexapp.com/ and their deal with LG. I run it on my Mac Mini now, but you can expect some consumer devices with it pre-installed some time soon.