Please, no Lido.
It doesn't work immediately on contact in gel form, so the insertion with it is as unpleasant as it supposed to be. Later on, it feels less sitting there for a couple of hours as the best but if the cath was removed during this short period of time, patient feels literally nothing and can experience full-blown incontinence, overflow type (in plain English, urine just flows out with no sensation wahtsoever). It is temporary thing, of course, but can be quite scary for someone who never experienced it before, not speaking about that feeling being absolutely repulsive and possibly delaying discharge (if the talk is about ER), and also increasing risk of urethral trauma because patient is less likely to notice, for example, pain. Since the usual mantra for very short-term/straight cath is 'it just will go in and out momentarily and nothing changes after that", having urine leaking freely for a couple of hours kills a good deal of trust between patient and nurse.
Plus, if the reason for Foley had something to do with acute neuro (cauda equina syndrome, spinal fracture, etc), lido will kill any chance for adequate neuro assessment in perineal area for good few hours, which can be detrimental in case of true emergency.
And, yeah, "dry Foley" is a torture even for females. Only one thing worse is probably taking it out after perineal restoration plastic surgery, and especially peeing the first time after that.