I have, or have used, RCBS and RCBS Lube 2, Lyman and the old, and excellent Lyman Ezy Lube grease that came in a metal tube and Imperial Sizing Wax.
I now use nothing else other than the Imperial unless I've put it somewhere and can't find it. It is that good once you try it you won't go back to other lubes.
As Muir's sound advice just use a barenaked finger to apply. Saving cloth or rag only for the wiping off.
However I have not used or tried the new aerosol or spray on lubes so can't compare with them. Nowadays, for my shooting, I load forty rounds at most at a session.
When I used to load a hundred or more at a session was ten plus years ago and using RCBS lube. In one way after sizing you just take all the cases and go and wipe them in front of the TV, or with the family, and a cup of tea. No hardship and a "break" from the gunroom/reloading press.