In my own experience, I haven't come across any sealant or wax that prevents water spots if said spots are left on the car for a while. Seem to just eat through everything if not removed soon after they appear.
And for the second edit, yes. Meg's Gold class in my foam gun. Foams up decently. Hopefully even better once I receive my in-line water filter.