ANY cable service is going to be better than DSL.
That being said, Comcast SUCKS. Their customer service is the worst customer service you will ever deal with. Their employees may as well be legally retarded. Their technicians do a horrible job.
As for the actual service, it varies. Expect it to suck for the first week or two. I've set it up in my apartment, both of my parents houses, my aunts house, and a few friends houses and EVERY single time theres been connection problems the first couple weeks. Half the time they don't register your cable modem as being active.
For all the headache though, I can't really complain too much about the actual connection after all the BS. I know my moms randomly goes out just about every time it rains though and the lines to her house have been replaced twice now.
edit: For years they were the only cable ISP here, but I've noticed they aren't quite as unbearable to work with since Verizon started offering Fios in the area.