I've worked in shops since I was 14, and used every lube under the sun. For the past 4 years I used White lightning, but recently switched to prolink. Wow.
It has everything you described you wanted. It has a very lightweight consistencey, is amazingly smooth, and despite being a wet lube, doesn't collect a ton of dirt or gum up your drivetrain.
White lightning was good for me, clean, and I only applied it about 2x a week, a little more if it was wet. Prolink doesn't flake off gunk chunks like white lightning, applies similarly easily, and is much much smooooooooother.