"Best car detailing products" is as subjective as which color Challenger is the best. A lot of it will depend on your circumstances; time, money, etc.
You won't go "wrong" using Chemical Guys, if all you want are the basics and ease of procurement (Walmart now stocks their products), but you can do better. I prefer many of the Mequiars products (again, talking chain store access). McKees 37 is also fairly available at auto parts stores, walmart, etc.
Above this bottom tier you then have to shop online unless you happen to live right near a distributor. I'm talking about shopping at Autogeek, or Detailed Image. Both are great sites because they carry a wide variety of brands, and more importantly, have blogs or forums specifically for detailing where you can learn a lot about both products and "how to".
True detailing (aside from simply washing and waxing) can be time consuming, and requires a bit of investment (call it $200 initially) for good tools such as a DA (dual action) polisher, pads, microfiber towels, and your products.
Again, a lot is subjective; I know some very skilled detailers who love Adams' products, and others (like myself) who are more "meh" about them.
My best advice is start with buying a very basic DA (Griots, Harbor Freight), some quality pads (I prefer microfiber pads over foam, but started with foam), good basic polishes like Mequiars, and a decent powerwasher. No, a foam gun on a garden hose won't really do the trick; you need some "oomph" behind the water to combine with the dissolving/lifting action of the foam (which is the whole point of the foam in the first place). You don't need to generate tons of foam; some of that is marketing hype and for show. Get a good pH neutral shampoo, regardless of whether it foams a lot, like 3D Pink).
Learn how to use a clay mitt (I've actually come to prefer them to the actual clay bar) because, just as in building a house, you have to have a solid foundation upon which to build a truly effective finish to your car. Autogeek, Detailed Image, and YouTube are very good sources of information. On Youtube, look for the first few years of the Junkman2000 series of videos; back before he cashed in, he was truly a "shade tree" detailer and gave detailed instructions on how to clay, how to use a DA, etc. He's now more of a marketing spokesperson, but his early videos are what taught me.
The key is to make your car's finish as hydrophobic as possible; this means the water (and any contaminants in it) just won't be able to sit still on your paint. The key to this, is to remove any and all contaminants already stuck to your car. You may think you don't have any, but unless you've clayed, you do. Put a thin plastic grocery bag on your hand, and ever so gently run the pad of your fingers over your "clean" paint. Via the bag, you will both feel and hear all the little microscopic contaminants stuck on your paint (really, the clear coat, but whatever).
These are what you have to remove via the clay bar/mitt; once these are gone, whatever finishing product you choose (wax, sealant, ceramic) will have the flattest surface achievable to bond and thus shed water.
Learn "how", then begin using the basic stuff like Mequiars. Once you're comfortable doing the "how", and satisfied with the results, then start experimenting with different products, adjusting your "how" as you go. If I had tried to use Menzerna polishes at the beginning, I would have given up and never used them again. But since I learned through trial and error the outcomes of too much polish, or too high a speed, or drying it out on the Mequiars, when I became skilled enough, the true quality of Menzerna's products stepped up. Price-wise, they're not much more, but the final product (and the effort to achieve it) is worth the small premium.
If you're not really into car washing and waxing, you might want to consider getting your car ceramic coated. There's a lot to learn there as well, to avoid being over charged or not getting what you thought you paid for, but in the end, coatings reduce the amount of time you have to spend getting your car's finish just right.
