In the past I've had problems with cable and not problems with DSL. It's all depends on where you live and how luck you get though.
A long time ago I started out with Bresnan (now Charter) cable internet. It was atrocious at first, but that was during Beta testing when it was free. It got better, but there were still intermittent problems with it through its whole life.
I had a QwestDSL line for 1.5yrs and never had a problem with it (3rd party ISP providing bandwidth on it). Considering it was 1.5mbps/1.0mbps it was basically like having my own T1 and probably the best net access I've ever paid for.
Then I had RoadRunner cable for one month, and had almost continuous problems with it, even after two service calls. So I ditched it.
Now I have BellSouth DSL, which is a bit on the overpriced side, but the bottom line is I get a static IP and it has yet to be problematic, so I'm going to stick with it for the time being.
-J