I'm sure the cable companies would still offer some package deals that most people would still buy because they would be better deals, even with the garbage they don't watch. But many of us who don't want MTV or Spike in our homes would have an option. I get annoyed to even have the names of some of these sex-filled programs on the pay-per-view channels flashing on the screen while my kids are flipping channels.
I feel the same as Dems_R_Losers. We don't want to watch local broadcast, sports, or shopping, although I'm sure that's a great deal if those are the channels you use, especially if you can't pick up local broadcast reception very well.
When we had satellite back in Oklahoma, I think we had to get almost 100 channels in order to get the 10-12 we actually watched.