99% of the time, all I use is engine oil. Nothing wrong with using Lubriplate or STP oil treatment- but IMO, it's unnecessary in most cases. But I mostly overhaul industrial diesel engines, which use roller cams in most cases. Something a little more substantial is usually called for with flat-tapped cams (especially breaking in a new one). STP oil treatment works fine for this, and there are lots of assembly lubes out there made specifically for camshafts.
One time I rebuilt a French-made John Deere industrial engine where the manual specifically called for black molybdenum grease to be used on the camshaft and tappets. I did exactly that- out of curiosity as much as any deference to the manual. It immediately turned the oil sortof an opaque gray/black... but seemed to work fine.