The "sport" sunscreens are in general more "waterproof", even though they can't use that term any more. The original Bullfrog used to be the standard for that, but it mostly used beeswax to help it bond to skin. It also wasn't great for acne prone skin. It not only stuck to the skin, but it also stuck to anything else. I heard it was popular with surfers, but sand would also stick to it. I used to wear it riding my bike, and if there was any dust or pollen I'd have a nice coating. I do remember when Coppertone Sport was kind of the standard for sweat proof sunscreen that wasn't quite as sticky. It's changed a lot over the years though. A lot of the spray sunscreens are nothing but the active sunscreen and some sort of plastic, so those will stay on aggressively.
There are some sunscreens that use silicone oil. It's good in a way, because it's somewhat of a lubricant that makes it feel less sticky. The main issue is that they will destroy polystyrene plastics, including ABS. The worst for me was when Neutrogena had a spray sunscreen that included a polystyrene cap that slowly started to warp from contact with the sunscreen. If you use that, you need to be careful what you touch. Here's a discussion on that.
https://www.reddit.com/r/SkincareAd...creen_dissolving_plastic_electronic_products/