Here is an excellent article on Cable vs. Sat
One of the main factors to consider is whether or not you want hi-speed internet, I dumped my DirecTV, which goes out every time there is a bad storm and got Comcast Cable. I only subscribed to the expanded basic but it has all the channels that are the most popular and having the cable internet blows away DSL, I find myself watching less and less TV, so why pay all that money for channels I don't watch? Comcast now has On-demand pay per view, which is great if you like movies. According to the article, cable is better for hi-def as well.
Some of the people who dis' cable paint with a broadbrush, I worked for Adelphia Cable and their service sucked. I have also worked for other cable companies whose service was not that great. After signing up with Comcast, I am so impressed by the service (phone call answered in THREE minutes by live human) that I am considering a position in marketing with the company. When you think about it, having every individual home needing its own receiver is a terribly inefficient way of delivering a signal. I really feel cable is the future. Comcast is also rolling out telephone service.
DirecTV has an excellent marketing plan that locks customers in for a year and gets them hooked on their product. They constantly blitz their customers with on-air self promotion about how great they are during the local avails, the time cable companies sell to local advertisers. Anyway, after awhile dish customers get brainwashed and fail to properly evaluate their options. A lot of people think of the cable company as the bad guys but doesn't Rupert Murdoch own DirecTV?
Now don't get me wrong, DirecTV is a good product (had them for three years) and one learns to live with the outtages but, especially for those wanting internet, cable trumps the dish. Even without internet, if you want the TV channels that most people watch, and want it in multiple rooms, cable is cheaper and more reliable, even after the promo period.
One final note, as the article states, which one is better is a personal choice, for instance, if you are the ultimate couch potato and want all the movie channels and every sports package known to man, DirecTV might be your choice. OTOH, you could subscribe to basic cable for about $40/mo in multiple rooms and get the movies you want to watch from netflix for $14.99/ mo. This would save you about $25.00 per month over DirecTV's complete package.
OH BTW, I didn't mention it, if a little storm knocks your dish off course, get your checkbook ready.