Here are the tapes I most often use on set:

1. Medical Transpore tape (same as micropore above)_works well for placing lavs on actors skin and clothes.
2. Medical Cloth tape (white)_When transpore doesn't work and for concealing wires on or beneath white clothing.
3. Waterproof medical tape (skin tone)_used occasionally for moist situations and for concealing wires on see-through clothing.
4. Black Gaff tape (2 inch)_For various mounting purposes (try not to use on freshly painted sets; it will cause damage).
5. Black Paper tape (2 inch)_Used sparingly when Gaff tape is too rough or when I need to temporarily mount things onto camera that won't need velcro.
6. Blue painting tape (2 inch)_For placing carpets on floors and for mounting small objects on sensitive surfaces; just make sure it's not in the shot (light blue tape will shine on screen)

I've used the silicone 100mph tape while working with a sound mixer from Holland (Antoin Cox; one of the best I've worked with) and it was amazing for quick fixes on damaged XLR cable. I haven't yet looked into buying some of my own. I haven't needed it, but I would love to have a few rolls just in case.

Happy tape hunting,

E. Santiago

I forgot to mention, but I also have Dr. Scholl's moleskin for occasional uses as mentioned by NoiseJockey, but I don't use it often (maybe I should; he makes a great point with concealing lavs, particularly when placing a Sanken COS-11 in a tie). Another great tape mentioned is the double sided wig tape named "Top Stick". I don't use it much, but it's always hanging around for situations where I need to conceal a wire within fabric while keeping the fabric from moving around. Sometimes you have to tape part of the actors wardrobe together within areas that will be on screen; Top Stick does a great job being virtually invisible to camera when placed underneath areas around or on a lavaliere mic placement.

Have fun making sound for movies,

E. Santiago

Ice Hockey tape is also an option. Cloth, sticky but leaves very little residue.

Quickly unrolling parcel tape is good for making electrical arcing/spark sounds.

Joes sticky stuff is great.

I have taken a liking to a tape used in the sports medicine field known as kinesiotape, I use that as a substitute for moleskin. Also an item which is not tape but kind of goes hand in hand with concealing lavs is antistatic spray.

+1 to what everyone else has said, they are all in my kit plus my above mentioned.

Every potential tape will show its feature and you too might have concluded with a number of points. Only get a control over the O/P impedance and a must check with the noise level after every stage of use. Because there are rat holes which appear to us naked….Rest yours...BOOM!!!

Top stick and gaff tape

Duct Tape. Because it turns, "no, no, NOOO!" into , "mmm, mmmm, MMMMMM!"