Scotch 33+ is the standard tape.
I won't use the cheap chinese crap from Harbor Freight or the house brand at Home Depot for anything that has to stay stuck, has to last, or anything important.
The two way radio industry uses Scotch 88 for antenna tower work. It's a little thicker, stickier and a lot more sunlight-durable.
One trick that is common when wrapping the antenna connections at the top of a radio tower is to put the first layer (Scotch 88) on with the sticky side of the tape outwards and for an inch each side of the connector. Then once that is in place we put a layer of mastic tape over that for an extra half inch each side. Then a layer of self-vulcanizing tape over that for extra half inch each side. Then a final layer of Scotch 88 over that with the sticky side in for an extra half inch each side. This way each layer covers the ends of the previous one.
The final result is that if you have to swap the antenna 15-20 years later (some better ones last 30 years) you just cut the splice lengthwide and peel it off... the inner layer having the tape outwards means that there is no tape residue on the antenna connections. It makes it so much easier to do the job 50 or 100+ feet up in the air in a 30mph breeze...
Semi-retired technogeek...electronics / computer / 2-way / ham radio... WA6ILQ (45+years)
1985 Fleetwood 32' Southwind (Chev P30/454/TH400), dubbed "Lazarus" by friends... I resurrected it from the dead...