IMO, the difference between the two are:
Spray Wax = thinner wax than even the liquid waxes. In this order...Paste, Liquid, Spray. The spray wax(s) may in fact be a silicone or wax based product and do offer some level of protection, shine & longevity and may leave white residue in the process. But, probably not the level of protection of a full past wax(wax or silicone).
Detailer =(Quick Detailer, Wax-as-U-Dry, Mist & Shine, Show Time etc.) are a thin milky or clear solution that are mostly a silicone based product that offer some level of protection, longevity & shine, after regular washing, which is also good for the "between waxing". The detailer(s) can also be used after waxing for that extra level of shine and swirl/streak mark removal on dark color vehicles.
In addition, detailer type products can also be used on black/flat black or colored moldings, plastic & trim. Some say that the detailer products can also be applied to the windshield to offer that "Rain-X" type protection and water shedding ability. I haven't tried this yet.
Detailer products are all I use now and I use them after each wash with great results. Often only using the detailer on the top portions of the vehicle(hood, rood, trunk) where the sun beat most but mostly doing the whole vehicle otherwise. I Keep my vehicles well into their teens and the paint never fades or oxidizes and always looks brilliant.