IVe never tried DSL, but I love my cable connection. Unfortunately, both are terribly expensive in my area, at least the high speed connections are expensive (around $100). I use the 3 Mbs speed because I work online, and often download files that are over 1GB in size. If for some reason our cable goes out, we have a backup dialup account to get online. If I chose DSL and the phone service went out, then I'd be out of luck.
Either way, you're going to see an incredible difference, and the internet will be easier to get addicted to