Any tape that doesn't come off is just fine. On a painted metal
sailplane, the adhesive is a bit more critical, but on gelcoat, it's
not as much an issue.

Some tapes have better adhesive, so the tape doesn't come loose under
temp changes and start to buzz - very annoying if it happens at the
beginning of a 6-10 hour flight.

Some adhesive leaves gunky residue. Some tapes split in cold weather.
Some sailplanes have some compound curves that require a good stretchy
tape.

There's some "religion" in picking the right tape

I like Mike Bowlus' "Maxi Tape". Not the cheapest around, but it
sticks wery well, stretches and goes around corners very well, and
doesn't leave nuch residue when removed.

-Tom