The way I see it, the level of granularity I desire is directly related to the pricing. Something less expensive should have less granularity; something more expensive ought to have more granularity.
Cable is a good candidate for the "more granularity" category both because it's naturally easy to segment, and because while monthly bills are not large, they of course add up fast.
For an example of a product (rather than service) that can benefit from more granularity, consider computers. Even Apple, our paragon of non-granular pricing options, offers ~4 SKU's for their higher end laptops.
If your product aspires to be that complicated, you're probably doing it wrong.