Mobil1 for contact point lube. It stays put but isn't too thick. Makes a great wipedown oil too IMHO. Just a few drops on a soft cloth.
I generally don't care for the spray oil products as they can get all over the wood. Some have teflon and other ingredients in them that get into the wood and cause problems for me.
Used very carefully, CLP & Ballistol however are a couple of good ones that serve well. They clean carbon deposits easily when that's the type of work needed on stripped parts. Ballistol works pretty good as Muzzle Loader patches lube too.
Straight petroleum motor oil,,,only in a real dire situation as there are so many other well suited products available. I wouldn't hesitate to use it though if there was little or nothing else.
At one time, 3-in-1 oil was touted as the best lube in the world for fine firearms and other delicate mechanisms.
Parker Shotguns advertised that it's use in their guns was the best way to go.
Times have changed and there are better products available. But in a pinch,, 3-in-1 will do,,just like motor oil will do.