I ather agree, so the heavy grades of oil are not suitable.
I haven’t used a motor oil because of the additives. Not that there is much wrong with the addititves for our purposes – its just that we don’t need detergents or acidity modifiers, nor the temperature stabilisers. They are pretty expensive without improving lubricating performance (for our purpose).So I’ve used SAE30 horticultural oil – which is engine oil without the additives(for lawnmower engines), and much cheaper too. Its designed to cling to a surface at the molecular level, which it needs to do, but you don’t get stiction.
Of course you don’t actually want a film technically- because that allows unwanted movement. Life isn’t perfect though, so you want as thin a film as you can get away with without metal to metal contact.
I was given and am now sold on Rocol slideway lubricant – spray on. Stays like hell on a surface, (it uses an electrolytic bond I’m told), which is exactly what is needed, and there was a noticeable improvement in “slideability”. So I use that on all slides, and the SAE30 for all the bearings and things that need “injection” – in cluding the occasional squirt into thesaddle/slideway lubricators to clear out muck – if any.