Superlube on the needle taper does help a little in combating tip-dry, but it doesn't last long in that context, for obvious reasons. As a lube it's nothing special, and as other's have mentioned it does dry out and cause minor sticking after a while.
Badger Regdab has the best actual lubrication of the lubes I've tried, by a very wide margin. A little on the needle shaft, and brush action will feel like the bearing got loose or fell out somehow. It also doesn't dry out, unlike Superlube. Downside is it has a very watery viscosity, so it's hard to apply without it dripping or wicking to other areas. Badger had an indecent some years ago where an entire tainted batch of lube made it to market, and their reputation is still on the rocks as a result of bad experiences people had during that interval. You'll see people saying that it's bad B/C it turns yellow and gummy, but this is not accurate to the stuff that's currently on shelves. I've got a 2oz bottle of it I've been using for around two years now, and it's great stuff.
K-33 is a grease instead of a fluid, so it's very easy to apply precisely, and it also doesn't dry out. Downside is it only lubes a little better than Superlube, and no where near as well as Badger.
On my Iwatas I use Badger lube on the needle shafts/bearings, and that's it. Iwatas have clean machining and nice smooth plating, so the trigger assembly and other bits don't really need any lube. On my SOTAR I use Badger lube on the needle shaft/bearing, and K33 on the trigger cutout & rocker. Badger's machining is rough, and the plating is thinner than Iwata's, so the 2 SOTARS I have need lube on the trigger assembly or else the action feels intermittently scrapey/grindy. K-33 is better for those bits as it stays put longer.
I used to put Superlube on my needle tapers to help with tip dry, but don't bother anymore since the difference is minor and short lived.
BUT, squishy and DaveG are correct: you don't actually NEED any lube. A decent AB will function perfectly fine & comfortably without any. It's just sort of a minor optional tuning thing, not an essential maintenance thing.