Welcome, AJ.
I love the new clear 3M duct tape - good stuff! Have some in my kit right now. It seems to have different properties than conventional duct tape (maybe my over active imagination), so I don't lump it in with the others.
My #1 favorite - because it works the best - is military duct tape. I have no idea who actually makes it and no incentive to find out, because I can still scrounge a roll of the real stuff.
My second choice is not the best of the commercial-off-the-shelf, but I can find it anywhere - it's the best 3M stuff. There is a better brand (google duct tape - a couple of informative sites), but I don't even recall what it is, because I rarely find it on the shelf.
Everything else is third choice. Even cheap duct tape gets most jobs accomplished (it might take more and/or more layers). And the cheap stuff is great to give kids who are playing with large cardboard boxes, scrap lumber, etc on a rainy day... it keeps them from using your good duct tape <img src="/images/graemlins/tongue.gif" alt="" />
Tom