I currently have DirecTV satellite service, and I previously had local cable service. It's not perfect, but I much prefer satellite to the former cable system. The installer did have difficulty locating a suitable line-of-sight for the receiver, however, and he charged an additional $75 for installing a pole in the side yard to hold the receiver. If you have a home with a lot of large trees in the yard, you may have the same line-of-sight problems when trying to install the dish on your house.
We have lost reception a few times during heavy rainstorms, but the interruption has rarely lasted more than a half-hour or so. Once the signal is disrupted, the system goes into a self-restore mode and usually comes back after a reboot. I wouldn't consider it a deal breaker, though. At least you can tell it's trying to recover, unlike being at the mercy of the cable company's repair schedule.