If you want seriously better grip and still excellent dexterity, think about latex surgical gloves. They also work very well for loading magazines, great grip and your hands stay clean.
If you are one of the guys that prefer more lube (as opposed to shooters that prefer a 'dryer' experience), and you use petroleum based (and petro-based synthetic) lube, nitrile gloves will not deteriorate when exposed to the oils; however the grip isn't quite as 'sticky'.
Want to draw stares at the range?
Bring your pistol and loaded mags in vacuum-sealed baggies, , then 'glove-up' before you open the pistol case and ammo box, slit open the baggies, shoot and carefully police-up your brass, then leave hastily. They'll remember you for a long time.
Do I wear gloves to wank? Why would you even ask that?
Sometimes. Soft deerskin or suede is nice (keep it dry) and latex gloves with lots of lube is good too. Of course when I'm handling firearms, what I want is a really good grip, when I wank the exact opposite is generally my desire, so the analogy is a bit flawed, for me anyway.