For truly “amazing” tape, I remember something from my Air Force days: “F-4” Tape, Orange, slightly stretchy, stretch while applying and it sticks to itself. Peel off the liner and it just works. We used it as temporary window seal on a B-52: all I can say, is two layers and two hours later, it was holding pressure at 42,000 feet. . .
Apparently it’s available commercially, F4Tape