Wow, surprised to hear so many differing experiences. Strange.
We switched to DirecTV in 1999...here is our experience:
Weather: Very little outage...the storm has to be severely strong, and as soon as the violent portion of the storms ends and it goes back to just rain, the service comes back on immediately. Honestly, not sure if cable has changed, but when we had Cablevision we had more service outages (not usually weather related) than with DirecTV.
Customer Service is fantastic at DirecTV. It could have to do with the fact that we spend a fortune on sports (NHL Center Ice, NBA League Pass, ESPN college football Game Plan, ESPN college basketball Full Court, MLB Extra Innings, NFL Sunday Ticket), and we are on auto-pay and have been for years, but they are always giving us something free. I call every year in August and this year they once again gave me Game Plan for free, and gave us $345 in credits toward the $300 Sunday Ticket price...they're paying us $45 to receive every NFL and most every college football game!
Also, I have to mention the DVR. We have the genie HR34, which has five tuners (meaning you can record four shows and watch a fifth) and has over 200 hours of HD capacity. Wonderful.
One downside is DirecTV does not carry the Pac 12 networks, which bugs me...the Big Ten Network is fantastic, and I'm sure they'll pick up the SEC Network when it launches next year...I understand DirecTV is trying to keep programming costs down, but Dish does carry the Pac 12 Networks, so I don't see why DirecTV can't come to the same deal. Not sure if cable carries these or not.
As you stated, the Champions League (and also Europa League) coverage is phenomenal. Every game is shown live...every game! I also love all the additional tennis channels DirecTV gives you during the tennis majors.
A Cablevision rep shows up from time to time to try to get us to switch back to them. They've got to be kidding me...