DSL was a complete pain in the rear to get set up... After weeks of Bellsouth delaying the activation date, they finally activated, and long behold, it didn't work. Of course, that was using a USB modem which was just a tad bit faster than a limping chihuahua. Anyways, the speed problem was more of the computer's fault. When I reformated the HD, reinstalled Windows, and installed the crap for the DSL, it was noticably faster. Six to eight months ago, I bought an ethernet DSL modem off of eBay. I got it working with no problems, and it was SO much faster. It's only been down once in the whole time I've had it, and that was even a scheduled downage to upgrade...
I am, however, thinking about changing to Comcast Cable. They've bumped the bandwidth to 3.0Mbps down, a huge increase. My neighbor has it and it seems to run great. DSL is coming cheaper than cable at the moment, so if money is a factor, I'd highly suggest DSL. But if you have a little bit more to spend, cable is currently offering better performance. It really does break down to preference. Its also a good idea to check with your cable/phone company to see if you can get discounts for combining services.
Just my $.02