I have had standard cable, digital cable, dish network, direct TV, digital cable and direct TV, and now just digital cable again. All of them have their pros and cons.
Standard Cable is cheap, but the quality is cheap too. The picture is grainy on larger screens, and you cannot take advantage of digital sound and picture. Also, most standard cable packages are limited to a total of 99 channels, and at least 35 or so are nothing.
Dish Netwrok is very good for digital picture and sound. The prices are good as well. The equipment is outdated and not very stylish (if that matters to you). It also does not integrate very well with after-market DVRs like Tivo, but I do like the Dish Network brand DVR (though it will not chase your shows like Tivo). Dish uses MP3 decoding.
Direct TV used to be the best of all worlds with MP4 decoding (a little better picture and sound than Digital Cable and Dish Network), and a partnership with Tivo that made their DVR the best built-in option. They were the first to offer HD DVR functionality. They are also more expensive than cable or dish network, but I found them to be worth it. That is until they went away from Tivo. Their new DVR is awful. So bad that I canceled our service over it. I also didn't like the switch to satellite (XM) radio over digital music channels. I don't think they are worth paying more for.
Digital Cable is good, but again, the built in DVR is lousy (Comcast offers Motorola, which is crap for crap). Still, I like the ability to use a great after-market HD DVR (I use a Tivo series 3) and to get on demand from the cable box (all installed in a central location in our home so that we can watch either the Tivo rot he cable box on either TV...yes, we only have two.) Cable doesn't go out in storms, which only happened occasionally with satellite, but it did happen on occasion.
I don't recommend having both. Don't waste your money. I bought a great HD antennae that was installed at my home (bought it from Tweeter/Hi-fi Buys) for $250. It is in the attic, out of sight, but it gets great reception. The picture never goes out, and the local channels never are gone, even when cable does go out.