Hi Rimfire Newbie,
My understanding of the red dot sight is that it allows you to have both eyes open and focus only on the dot which is superimposed on the target. No more fuzzy front, rear, sights and target. There is no magnification.
Have not shot with one yet, but aimed one mounted on pistol in the store. This is the system used by most bullseye pistol competitors and apparently helps the "old" eyes, mine are 60 so I just ordered an ultra dot and SoLow mounts for my Ruger MK 11.
I would look at a red dot mounted on a pistol before going for a regular pistol scope with magnification, I think you may like the red dot system.
Regards, BeachDawg