Here’s a great New York Times article about the upcoming content battle for your TV between companies like Google and Apple vs the cable companies.
We ditched our Comcast service a few months back and have been using the Apple TV ever since. It’s been great so far, but you do miss out on live TV (comedy shows, news programs, sports, etc). The rumor is that the new set top boxes that will be coming will be able to solve this problem through relationships with the content providers.
I’m optimistic that this problem will be solved by these guys but also think that they’re going to have a tough time given that the same people they’re fighting (cable companies) also provide the pipe to enable them.