Apologies for brevity of my earlier post - I was in a rush...
There are more grease thickener base types and variation in base oil than you can shake a stick at, all tailoring the grease to the application. Basically though, to gain in one particular property, you are probably trading away another possibly more useful property. A certainty if the wrong choice is made
Skip silicon, feels slippy to the touch, but is a rubbish lubricant. Buy a can for your door seals, but that's the end of its automotive capability.
The requirement for a wiper mechanism is penetration - think for a moment that most greases have grease gun application in mind or assembly of parts where application is easy.
So an aerosol grease with a solvent to aid penetration which then evaporates leaving a firm grease behind is more appropriate here.
Either a general purpose lithium based one - a specialised industrial type designed to penetrate chains and/or wire rope best of all but hard to obtain - or consider a chain lube as used on motorcycle chains. Find a good product and then use it everywhere - door locks and hinges, brake pedal pivots, handbrake mechanisms, etc, etc, etc. Does wonders for keeping a car feeling 'sweet'.
Waterproof, in this context means it wont readily wash out when exposed to the elements.
edit PS. Re aerosol lithium grease - Wurth and Comma both have which should be readily available from your local auto shop. If there is a Castrol one - take it. There may be others though. Or bike chain lube, but don't be oversold on the anti-wear additive - a decent base oil is more useful. You don't need Moly!
