As for a Hard Paste Wax, and if that's what you ideally want, you will search the world for a wax that will last longer than Collinite #476. Now they might be out there, I haven't tried every uber cutting edge euro-foreign product out there, but in any case, doubtful you'll ever find as durable a paste at #476's price.
Hard to apply, or remove Colly #476? No, not really at all, if it is applied correctly, (And not a 10 year old can of product) and like all other good pastes, this one IMO should not be applied in direct sun, or to hot paint, so for a "Wax at the Carwash", this one might not be the ideal pick?
If you want another inexpensive pick, with again very good durability, then the Duragloss products come to mind, such as 105, 111, and then use something like Duragloss Aquawax Spray at the car wash for a quick detailer.