Cams for Dummies ??

I would like to understand how to pick a cam, and how all the other factors affect selecting the right cam. I'm not an idiot but just reading what I can find here it's like the harder I try to get it the less it all makes sense.
Problem especially with street cam some of it comes down to your level of compromises and preferences. Most are gonna have different takes on best cam leaving ya confused to which one.
Best learn a bit then pick couple of cams you feel are right then ask for peoples opinions on them.

Is there a good book, website, or tutorial I can use to get a handle on this?

TIA!