"SuperLube" as in the blue stuff that comes in a tube with Iwata airbrushes? It is actually not a very good lube to use at all - it tends to thicken and gum up over time. Most of the time in the air valve. I believe Iwata has just changed the formulation of the stuff, and it is now clear -although I have not tried the new stuff, yet.
It is my belief that airbruhses generally don't really require lubrication. They just need to be kept clean to function as designed. With that being said, I have actually tried just about all available lubes
, at one time or another. There are some airbrushes that use either a pin or post running through an o-ring as part of the trigger mech. This sort of construction can benefit (in terms of feel) from a small amount of lubrication - for me, the one I prefer above all others is Airbrush Balm from Foxy Studios. It is not an oil, but a thick bodied, translucent grease type substance. It reminds me of food grade silicone grease, but I have no idea what it really is - A very small amount burnished onto the surface you intend to lube does a really fine job...