Well, let me just say, I started looking at this forum in 2004. I had to learn a lot in a short period of time, what ends up happening is you look at one thing and find 10 others. I stopped looking stuff for a long while and now I am back in to it and there is a whole host of new stuff, so you're always going to be presented with a ton of stuff you can use and a lot more on how to use those products properly.
What I would suggest is using a "Goal oriented" approach to figuring products out.
For example:
What do I need to do first?
Wash the car
What products do people seem to like to use to do that? start preferably with something a lot of people seem to like and that is easily obtainable. Start there and experiment see how you like it, try to remember what that product did for you. If you feel it hadn't met your goal, look for something else, and ask yourself, "where did this product fail me?" And look to see if other people had the same problem and what products they used to rectify it.
What do I need to do next?
Prep the paintwork
Same as before, your new goal is to prep the paintwork, compare against what you need to do and what you have. Example: "This car is 10 years old, I need to remove oxidation and swirls, what product can do that for me?" and again start with what most people seem to like first and what is most accessible, use this as a "jumping off" point. The more experience you gain with those products will lead you to where you need to go next, this is how you learn to distinguish and ultimately find the product YOU want to use that works well for YOU.
I think to start off, using this step-by-step goal oriented approach is probably the best way to get your acquainted with the sheer variety of products available out there.
Eventually, you'll find yourself in a place where you realize you've got a routine more or less down and you know where to look for a specific problem that may arise, THEN you can REALLY participate in the debate aspects.
Everyone has their different preferences and styles and it's important you develop your own, you may find yourself looking for the best way to solve a specific problem. But you have to start somewhere and that's why I suggest the above.
I hope this helps you somehow!