There ARE differences in products, but more by CLASS of product than brand. Polymers (Klasse, Zaino, Blackfire, Meguiars) provide the best longevity. Polymers need to bond with your paint - therefor if paint cleaning prep work is required first, you have to wash your car to remove any fillers or oils introduced in that step before applying the polymer. They produce a shine that some people like and others don't. Some people describe it as "bright", "hard", or "plastic".
Carnaubas (Pinnacle, Blitz, Meguiars, Zymol, others) vary a lot - from cheap to very, very expensive. They provide a different kind of gloss than the Polymers. Many describe it as "wet" or "deep". I have seen both polymer and carnauba finishes on my own car, and although I would be hard pressed to explain it or even articulate any further what the differences are, I have to admit - I agree with these assertions.
There are also "blends" that try to combine the best of both worlds - and usually end up a bit of a compromise (which may be wat you want.) One such product that I know well is Meguiar's Gold Class wax - it is a polymer blend that won't last quite as well as a polymer-only, but also has some of the properties of a carnauba wax in its look.
There are other classes - mostly silicone-based weird stuff - I don't think many people here like or use them.
Finally, there are tradeoffs in the time and energy required to apply each and buff it out. Some are hard in both steps, some are hard in one and easy in the other, some are easy at both. Some leave a lot of white residue around - especially visible on black trim. Others don't.
SO - you need to decide what your priorities are. search this board on any of the above themes and you'll find plenty of discussion. The good news is that your color choice is great at NOT showing many flaws, and, to be honest, the differences between waxes won't be nearly as apparent.