One of the reasons many of these products don't perfom as well as one might expect, and others seem to get them to work well, is because occasionally people don't think about what the material is doing and how it works. It is important to use them intelligently,
If you have a thin type penetrating oil which disperses water out of a crack. (WD, 3 in 1 and many others) thats grand, but the water hasn't gone away (as a matter of principle) Its simply moved elsewhere. Eventually the oil will float (depending on evaporation rates of the wateretc etc.)
So the trick, in watery conditions like the bore of a steam engine, or tools in a poly bag full of damp air, is to dry the water off and respray. (With say a loco, its easy – pump the stuff in, spin the wheels a few times, and then respray, and no risk of a cylinder full of heavy oil creating a hydraulic lock next time. )
——
Again, I think it most unwise to say what will or won't stick to what, not unless one actually knows the subject. The chemists these days really have their act together, and just because a material is ostensibly slippery, it doesn't mean to say that it won't stick to something, using electrical bonds and the like. For instance preservative greases can look the same as any other grease, but have very poor charactristics under load. Some oils can be very good at rejecting water, cling to surfaces but reject small particles, and not be made of "oil" at all, but for example glycol.
So generalisations can be – misguided or possibly just out of date.