I've used everything from automotive grease to gear oil to automatic transmission fluid and a half-dozen or so specialized "lubes" or "waxes."
My uneducated opinion, at least in my riding, is that cleaning the chain with anything regularly is more important than what you use as a lube as long as what you use doesn't damage the o-rings and I'm not really sure my cleaning regimen contributes much to the life of the chain. I'm still on my stock chain at 13K miles, so it's still a teenager and I can't predict how long it or my sprockets will last.
80% of my riding is in the dust and dirt. The only thing any kind of lube does is attract dirt and dust to the chain, thus acting as an abrasive. I don't know: maybe a lube helps trap the contaminants on the outside surfaces of the chain and prevents them from migrating down to the outside of the o-rings: maybe it makes it worse.
I've been using a spray can of WD-40 and a Grunge Brush for both cleaning and lube for quite awhile because it's cheap and easy. I'm too lazy to remove the chain to clean it.
I spray it on, hit it with the Grunge Brush, "rinse" it with more sprayed WD and when I'm done I wrap paper towels around the chain and run the chain through them until it's pretty much dry on the outside, anyway. I made this a lot easier and less messy by permanently removing the stock plastic chain guard, the "safety" guard on top of the swingarm.
After I go ride 2 miles the chain looks just like it did before I cleaned it, anyway. I still do it regularly and if nothing else the WD keeps the chain side plates from rusting.