Most of the products at mass retail are very similar at certain price points. Each retailer offers a few "diamonds in the rough" but for the most part, they all carry the same brands and products. Mass retail is all about revenue per sq. foot, maximizing profit margins and turning inventory, not about offering the best variety of top notch products to their customers.
Having said that, there are some good products at retail in each category. JHZR2 has mentioned a few good ones but let me break them down for you. This is a basic list off the top of my head but it'll get you started:
SHAMPOOS - Meguiars NXT, Meguiars Gold Class, Mothers Calif Gold, 3M car wash soap
PAINT POLISHES - Mothers Pre Wax Cleaner, Meguiars Deep Crystal Paint Cleaner, 3M Swirl Mark Remover
SCRATCH REMOVERS/REDUCERS - Mothers Scratch Remover, Meguiars Scratch-X, 3M scratch remover (there are several good products like this on the market).
CARNAUBA WAXES - Meguiars #26, Mothers Calif Gold carnauba, 3M paste wax, Collinite 476S (Harbor Freight stores only)
SYNTHETIC WAXES/SEALANTS - Meguiars NXT 2.0, Mothers FX Synwax, 3M Performance Finish, Liquid Glass
RUBBER DRESSING/PROTECTANTS - Mothers Protectant, Mothers FX Tire Shine, Meguiars Endurance, Armor All Original Shine, Armor All Tire Foam, Vinylex
GLASS CLEANERS - Stoner Invisible Glass, Sprayway glass cleaner (at Sams Club, Costco)
WHEEL CLEANERS - Meguiars Gold Class wheel cleaner, 3M Wheel and Tire Cleaner, DuPont wheel cleaner, Mothers All Wheel cleaner
CAR DETAILING TOOLS - Use either lambswool wash mitts or 100% cotton chenille mitts for car washing. Most stores offer a good selection of microfiber towels for glass cleaning, paint polishing, waxing and post wash drying. Invest in microfiber and skip cotton terry and chamois' for car care. There are various small tools for tire cleaning, wheel cleaning, etc so try a few and see which ones you like best.
I hope all this helps. Let us know if you have questions.