Progressive has multiple die positions and when you pull the handle they all do work at the same time.
Turret has multiple die positions but only one works at a time.
Single stage only has one die location and works one at a time.
SO for less critical stuff like a pistol etc I would never go single or turret, get a progressive so you can spit that bulk ammo out fast. I shoot a mag of pistol in the time it takes me to shoot one rifle round, that means it would take me 12x as long to make all my pistol ammo than it does my rifle. Screw that.
For precision it could go either way, its entirely possible on a progressive (and many here do!) but it takes a bit more from you to set it up properly for great results and improperly could result in poor results in mass before you catch the mistake. It has potential for higher variance, not a guarantee.
A single stage is simpler and less to keep your mind on and mess up but you can still get shit results from it if youre not paying attention, you just dont have to be careful with multiple operations going on at once. It forces you to slow down.