in short:
DSL if you want Decidated, although typically slower overall, Bandwidth... ideal for applications such as Gaming, websurfing, downloading, etc.. uploading, file serving will be possible, but not very desireable
Cable if you dont care that your nextdoor neighbor can be running an mp3...