Options here in Austin are kinda slim.
From personal experience and gathering info:
Time Warner cable boxes suck. It doesn't cost anything beyond digital cable, but the 2000HD that I have is a piece of doo. I 've had several, because they keep breaking, and they all seemed different. One would downmix the 5.1 to analog, the other 3 would send the digital channels out the SPDIF, but silence out the SPDIF when the analog channels were tuned. This forces me to manually switch back and forth because my reciever detects the SPDIF silence as a valid signal and it takes precedence. The only HD offering on time warner is HBO. With the 2000HD box, you can't get PPV of any sort, or any of the in demand features (they will give you a second box for free, though)
right now, the only game in town is NBC. FOX is supposedly broadcasting, but I can't pick it up with my rabbit ears.
Supposedly, you get Showtime, HBO, CBS(we qualify in Austin for this). I think it even has an HD PPV.
DirectTV I think doesn't have showtime or CBS, but does have HDNet (eclectic programming, with lots of sports and plenty of reruns). It looks like HDNet has taken over the HD-PPV slot on directtv (except in the middle of the night). That's no big loss as when I subscribed, they played the same movie for weeks at a time only at 11pm central.
My choice will probably be DISH when I get my house built.