I'm an old school guy and use nothing but carnauba. Other waxes may last longer but carnauba gives me the best shine.
I started with Mothers® California Gold® carnauba. It was a good wax and always gave my car or truck a good shine.
A few yeas ago I received this Wicked Yellow Carnauba Paste Wax as a gift and was relay, real impressed. The stuff is as hard as a bar of soap and the can lasts forever. It also puts on a great shine on the car. The only problem is, I have to order it online because of no local dealer. I've been tempted to buy it by the case and sell it and just might do that.
http://www.wickedproducts.com/wicked...Paste_Wax.html
This year I used Meguiar's Gold Class™ Carnauba Plus Paste Wax. It was a good wax that gave me a great shine. I'll use it until the can is gone but may not go back and buy more. The wax has additives and is somewhat liquid, not what I consider past wax.
Best shine, probably Meguiar's, my favorite ,Wicked.
You can check out my post in his section that was done with Meguiar's.