Stay with the cable!!!!
I just switched from yahoo DSL back to Roadrunner and I'm loving it. The speed is faster and I don't lose the connection, ever. I was getting dropped 2-3 times a day with DSL (which may be the provider, but it still pissed me off).
One added benefit (and a HUGE one to me!)... I had to call tech support 2-3 times to get things all sorted out with the cable. EVERY time, I talked to someone who's first language was English! No hundu/kurdish/mongolian/martian accents, no asking them to repeat themselves 3, 4, 5 times. Always helpful and pleasant to talk to. If our actual installer would have been competent (and nice), it would have cut my tech calls down to 1.