The new one will have Honeycomb and the Market with TV-centric apps, which IMO means it'll have the potential to be pretty good.
There are almost no restrictions on apps, so you should be able to get everything from Netflix/Hulu/Vudu/Amazon/Google rentals to torrent apps and tv-centric games.