It's pretty funny how opinionated people are about this stuff. I used WD-40 for ten years and was pretty happy. I tried White Lightning, and decided I liked how clean it kept everything without being oily. The calf tatoos are much fainter. I've been using W.L. now for 6 years, and it's fine. I put it on once a week, just like WD, and it's just as quiet as WD. My parts all wear at the same rate as with WD. It costs about 10 times as much per ounce, but there's a lot less waste. <shrug>

From what I can tell, any lube will work as well as any other lube. Just choose based on availability, price, and the non-lubrication-related attributes you favor.