Screw on is simple to use and the cheapest option for the manufacturer (which is why it was so popular) but has some disadvantages:
- It can jam.
- It can unscrew in reverse.
- It is (even more) vulnerable to swarf in the thread or damage to thread or register (than other types) leading to or inaccuracies.
- Virtually all chucks will need a backplate.
Camlock is probably ideal for a production environment or if you can afford it. It's only disadvantages are cost and the need for a dedicated backplate for all chucks. It does take a modicum of understanding and care to use properly.
But you specifically asked about the best for the amateur. To me this means you need a secure, safe, simple and relatively inexpensive solution.
A bolt-on flange is simple enough for anyone to understand and therefore safe. Flange mount chucks are cheaper, a consideration for beginners. It's prime disadvantage is that it takes longer to use than camlock, but not much if you are used to it.
Another advantage, if you choose your flange dimensions wisely, is that you can choose a standard that allows you fit your commonly used chucks without the need for the extra cost, machining, weight and overhang of a back plate. This does not preclude you using backplates for other chucks.
So to reiterate, I think screw-on is an idea past its time, camlock is for jobbing shops where time is money and for more experienced hobbyists willing to pay the extra cost for added convenience. For ordinary amateurs, a straightforward flange is best.
I suspect camlock will be right for you, but if you choose a flanged spindle, use six, not three or four, holes so you can fit chucks with either three or four bolts!
Neil