When I detailed for others, I almost always used Klasse AIO. Mild Cleaning ability, good shine and seemed to last.
On my cars, I used to use Zaino and still think they are great products, but moved onto Duragloss' products. Their tire dressing is awesome as are their polishes-waxes. However, the AquaWax is something I use after washes and like a detail spray. Makes the surface slick and shiny.
I just did my SHO and Excursion (and Lincoln before them) with the Duragloss Enviroshield. It's a ceramic coating that is supposed to last 2 years. I first wash and then clay bar. Next, apply the Squeeky Clean that comes in the kit to prep the surface. Then, apply the coating. Basically, spray on an applicator and apply to surface.
The SHO came out very nicely....but the Excusion amazed me. I did the project over a few nights when I had time. After a couple days, it seemed like as it cured it got shinier. Looks great, feels slick. So far so good...