If I have time, I use a paste wax. More durable, lasts the longest. 3M Show Car Paste Wax, Meguiars Yellow No. 26 are two that I like. Both also come in a liquid form. But I have used a lot of different products that run the range of pricing, and they all have produced a great shine, some lasting longer than others. Including cheap Kit Wax. I don't recommend using that one on new paint, but if the vehicle is more than a year old, you can use it, but it is a cleaning wax. 3M makes a number of really good paint detailing products, some only available at auto body suppliers.
One person mentioned Klasse. I like their products too. The All In One red container is great. You can finish over that with the silver bottle, which seals real well.
Mother's pure carnuba wax.
Collinite is an old product that is very good. Basic wax products that don't have all the fancy claims of ingredients like most others.
Turtle Wax in the green bottle is great on chrome and for quick cleaning and waxing of smaller areas that may have some blemishes or for older cured paint with fine scratches.
You can't get a mirror shine with wax. No wax does that. The paint has to already be glassy smooth. You have to use an orbital polisher with compound or wet sand with real fine sandpaper, then compound, glaze and seal to get it smooth first. Then wax it. Then you have that mirror shine.