I have had CABLE, and DSL. They are both very good, and have there ups, and downs.
If you are going to be downloading and uploading alot of files, go with cable. If you are going to be surfing the web, going to lots of webpages, and gaming, get the fastest DSL line you can get.
Cable has a big speed advantage, in long term downloading. DSL Has a better burst download/upload rate, so thats why webpages load faster, and online gaming is better for DSL. When I had Adelphia 6mb/768kb my pings in battlefield2 where never lower then 80 in a us server, and never goes below 130 in a uk server. On my Bellsouth 3mb/384kb connection, my ping in battlefield2 never goes above 45, in a us server, and 60 in a UK server.
There you have it Cable better for massive and longterm downloads, DSL better for burst downloads.