In short, length of protection and overall quality.
The Paint Protective Wax is great for your daily driver that you're just wanting to get some basic protection on. It's miles ahead of the spray-on wax that you get in a drive through wash, but it's not the end-all-be-all of waxes and will last about a month.
Our Carnauba Hand Wax is what most people think of when they want their car "waxed." It's applied by hand on every panel of the car and provides about 3-4 months of protection depending on how you store/park your car. It makes washing you car even easier as dirt doesn't stick to a waxed vehicle like it does if it's unwaxed. It also helps against UV protection and clear coat failure.
The Ceramic Hyper Wax is synthetic blend that can last up to 12 full months. It has the same properties as carnauba wax, but it lasts much longer, meaning you only have to get your car waxed once a year.