I have a Creaform MetraScan 750 at work. It's pretty neat, can get 0.005" accuracy or less out of it. We also have a HandyScan with single line mode for very small parts.

Granted, at $150k system cost, it is slightly out of the layman's budget range...

An OpenScan kit is something that's been high on my list for hobby purchases for a while. It looks pretty functional from the YouTube videos I've seen and my printer is fully capable of making the frame.

Nothing comprehensive but the weapon holster company Trex Arms has a video review of the Einscan-SP that is like 5 years old.

Now I get that's not super helpful but the interesting part is that they scanned a ton of handguns with combinations of optics, lights etc to make their holsters. They found out how tedious of a process it was so they made the files open source. So you can see the quality you'll expect when you compare spec sheets to other stuff

I bought an old Xbox 360 Kinect and got surprising results out of it using Skanect

Just an option to throw on the table: https://openscan.eu/

What are you overwhelmed with? Which option to go with? What to expect as far as post processing? Accuracy? Something else?

Not sure of any beginner FAQs on scanning.

I guess it all depends on how much scanning you plan to do, the size of things you want to scan, and how accurate you need the scans to be. Out of curiosity, what are you looking to scan? Is it something that can't be modeled in CAD software?

At the risk of giving you yet another option - Teaching Tech did a video on a neat scanning rig called the OpenScan Mini. Looks like someone linked OpenScan below as well. You build it yourself from electronic components, a pi, a pi camera, and some printed parts. Results look pretty decent for what it would cost to build, and probably worth the time and effort if you plan to do lots of scanning.

Some of the newer iPhones feature a LIDAR scanner and there are store apps that can use it to scan too

I would like to get one for our club but I can't understand the wide variety of prices. $150 ? $500 ? $2000 ? $10000 ? $75000!! ? What's the cheapest that is not a pain to use ?

Your best bet is to do some searching around and find a company to do it for you. I work for one of those companies. I play with the real deal laser scanners every day and can confirm that there sure is a reason why a creality handheld scanner costs a couple hundred bucks and a Ziess handheld scanner costs 70k.