As with most automotive paint colors, the real trick is not in the type or brand of wax that you use on the car, but in the prep you put into it before you wax it. If your paint is flawed, scratched, swirled, etc.. then no wax is really going to look great.
However, if you take the time to fully clean, clay (if needed), compound (if needed), and polish the paint before you apply your coating, sealant, or wax, then just about any quality product is going to add to the pop.
Case in point - Here is a recent picture of my 2010 Fusion, which has over 249,000 miles on it:
When I bought this car, used, it was covered with spider-web swirls, light scratches, etc.. and looked absolutely terrible in the sun. I washed, clayed, washed, sprayed it down with Iron-X, washed, then did a full compound correction, then a polish, IPA wipe, and finally a thorough application of wax using my HF DA Orbital. That was a few years ago.
All that's on it in this picture is the spray wax that I put on after its latest wash - I used
Meguiars D156 - with whatever remains of the last coat of wax that was applied in November. I hit the car with a light spritz of Megs D156 after each wash, although I consider D156 to be best as a 'topper' and not really as a stand-alone 'proper' wax.
As far as good 'proper' wax to use - There have been many good ones mentioned so far. Among my favorites are:
Collinite 845
Finish Kare FK1000
Meguiars Ultimate