Generally speaking, the difference in performance is specific to the product. Some hard waxes don't last as long or shine as bright as the soft ones and vice versa. The advantage of a hard wax, from my experience is, it's easier to get a thin film with hard wax because the applicator will pick up less of it. The advantage of the soft wax is it may spread more easily.
Robert