There is no best wax. Some will have a more wet look, others may make metallic flake pop more. Some last months, others last weeks. It's more about personal preference. What you should really do is correct the paint, not mask it with wax. It will look much better, and when the wax wears off, you won't have all the swirls and imperfections back.
For what it's worth, I use Pinnacle Souveran. It's $95 a jar, though, I got mine years ago when it was buy one get one free. It also included an applicator pad and a Cobra MF towel with each jar. I've just recently about finished up the first one. My car's paint isn't in great condition (thanks GM for the orange peel) but here's a C6Z with the wax.