I've used cable, DSL , and wireless at my own residence, satellite at a friends.
Cable is a shared medium which means that everyone in your neighborhood shares the bandwidth. During peak time the speed may seem to drop but it will pick back up once you're out of the 'peak' times. Cable usually has more bandwidth than DSL on the back side connections and sometimes they allow 'bursting' above the 'limits' put on your cable modem.
DSL is dedicated bandwith. DSL quality will vary greatly depending on how far you are from a CO (central office). The farther you are away the lower you maximum bandwidth will be. You will almost always have the same download speeds because it's dedicated bandwidth just for you and doesn't impact others until the backbone connections w/ your provider (which are sometimes inadequate on DSL).
Wireless was GREAT. They put a small (12"x12") panel antenna outside and I got both cable TV and internet over the single panel. Worked wonderfully and I had great bandwidth. Not available in all areas though - mostly found where new infrastructure isn't available or too costly to install. www dot awcable dot com. This is the provider I used - and I'm sure they don't compete w/ the sponsors since they only provide internet/cable TV services in Fairbanks, Alaska.
Satellite has excellent speeds but the latency is horrendous. You submit a request and then it seems to take forever to get the page up. If you flip pages constantly you'll go crazy, but for large data transfers it's great. (I used satellite at a friends house).