I have the Hollywood brand one in the little tin. It’s very useful for things like fixing gaping necklines when you bend over or collars that won’t stay flat, etc. I’ve found it works better if you stick fabric to fabric rather than skin, because sweat or oil can loosen it. I usually stick things to my bra, which works pretty well.
Not gonna lie, I’ve used scotch tape in a pinch. (Or lab tape.). It doesn’t work that well - real fashion tape is much better!
For fixing things like gaping button plackets or securing wrap tops I think a good old safety pin works best. I always keep a couple on my key ring.