For the speed/cost issue, Cable usually beats DSL. It depends on where you live though and what speeds you can get for what price. With cable, you almost never have a choice. You get service, for a set price, period. With DSL, you can chose what you can afford, but it's usually a higher price for the same speed.
Ignore anybody complaining about how cable is 'shared' and slow. The nature of it being shared is not much different than how any Internet connection is shared. The aggregation point is simply one hop closer to you than with some other connections. But the cable aggregation point can have better connectivity than other connection types (a cable hub has 30Mbps of connection to the rest of the cable network, a router for standard IP traffic may have only a single T1 to the rest of the network).
For me, I'm very happy with my cable from AT&T Broadband (formerly MediaOne). I get T1 speeds downloading on a regular basis, for 40 dollars a month. I'd have a maximum of 640k download and 90k upload if I got Verizon DSL for a slightly higher price.