I've had all but Direct-TV but I've heard from several customers of Direct-TV that weren't the biggest fans due to the ever increasing cost.
Of the other services I liked AT&T's U-Verse but close behind that comes DISH Network/TV which has actually been pretty good to me and fairly competitive with Cable cost. Living where I live now though AT&T doesn't have the bandwidth to provide U-Verse service.
The reason I started this post is I was wanting to get impressions from others as to what their favorite providers are and why? Who is the worst, and why. Naturally I can say that Satellite TV such as Direct-TV and DISH is a problem during heavy rains, to the South of the house, and dealing with the outage during those times of intense rain or snow but I still prefer those outages to the performance, features and difficulty of dealing with Cable providers. I will though relate that some Direct TV folks have said that improvements have been made to the Satellite Dish sizes that they use for Direct-TV that enable it to have less outages due to weather.
I guess they all can be trying at times and aggravating at others.