I detail cars on the side, and have for over 25 years now. During that time, I have used a lot of wax, but my favorites (in no particular order) are:
1. Collinite 845 -- I've been using this for over 15 years now, and absolutely love it. VERY easy to use.
2. Meguiar's Ultimate Paste wax -- really a great LSP, especially if you have prepped the surface with Meguiar's Ultimate Compound followed by Meguiar's Ultimate Polish.
3. Poorboy's products, especially EX-P, since I can use it directly in the sun.
4. Wolfgang Deep Gloss Paint Sealant 3.0 -- this gives an amazing look to all different colors of paint
As with anything, the preparation that happens before the wax is applied is the key. The better the prep, the better the results.