I WAS thinking of getting one or two of these to replace some 100W incandescent light bulbs in my own garage, but not for detailing purposes but for general illumination. I also know that they make "stacked" LED lights that put out 5,000 to 10,000 lumens of bright white light that fit into a traditional light bulb socket fixture and take 15W to 25W of electrical power, depending on the brightness and number of lights in the "stack". Those, too, have come down in price.. The winged LED light that you referenced may be better suited to your needs for general illumination because you can "point" one of the wings in the direction of an area that needs such lighting, especially if you only have one light socket in your garage.
I agree with Stokdgs that you need some type of LED lighting that is perpendicularly-sourced or pointed at the horizontal surfaces of a vehicle.
Even less-expensive (AKA cheap) LED work-light that can be adjusted in its intensity (AKA, brightness) is a good start for "seeing" swirls, flaws, etching, scratches, waterspots, etc (AKA imperfections) in the clear coat/paint. What those LED work lights REALLY show is how much correction is required to perfect a surface and what looks good in "regular" light is quite bad when illuminated by a LED work light moved to various angles. Quite frankly, it also "magnifies" how well your buffing machine works and your detailing skills concerning pad choice and compound or polish used. It is almost to the point of being frustrating. It is also the reason professional detailers have multiple manufacturer`s compounds and pad types to try to obtain a "perfectly corrected" finish, and yes, sometimes it is trial-and-error experimentation. Having information from the experiences of professional detailers in this forum on what works for a particular vehicle`s clear coat and color is a big help, and yes , there can be differences within the same vehicle if it has been painted by body shop, but maybe with a different clear coat and paint than the OEM finish.
This is more-than-you-really-wanted-to-know, BUT sometimes an improvement or addition in detailing equipment may mean you need to also improve your detailing methods or get additional training to acquire new detailing skills.