The term Super Lubricants simply refers to high quality products.
It's hard to suggest a product for general use as for example the grease that you apply to brake pins would be of a different grease to that used to simply coat an axle nut as it needs to be high temperature grease for the pads, and on any nuts you want to protect on the exhaust.
As with most things in life (usually), you get what you pay for. My opinion - I always buy the best quality lubricants that I can find for my bike as it's usually only serviced once a year so the cost is minimal.
I would however suggest that you stay away from products that have bike manufacturers names on i.e. Suzuki 20/50w Motor oil as you can bet this is overpriced, not necessarily the best quality that is available and will not improve any performance despite what it says on the packaging.