I live in Toronto and am very pleased with my cable connection (@home). I have tryed to run a UT server and get the high pings that you describe. DSL is more expencive than cable here (39$ CDN for cable 49$ CDN for DSL) and I thing that cable is more stable from what I have heard.
The thing that I would like to mention is that I don't think cable is good if you are looking for doing servers for anyting as the cable prviders have an upload cap.
All internet and game speeds are great for me,(avg. 200K/s dl's) but running a server is out of the question and I never expected to run a server though. Its not really fair on the shared bandwidth.