Minor additions/+1s to all he said:
Because you use target focus instead of front sight focus when using a red dot the dot is going to be fuzzy, anyway...
When trying to decide if the dot is too fuzzy to use for you Do Not Look At The Dot. Sure, it'll be focused at infinity so will be "in focus" when you are looking at the target but do not... let's say, pay attention to it. If, when aiming, switching aim, etc. it is just a red dot and you can aim and click/bang: all good. If it's unclear what part you aim at, makes you want to slow down and figure it out, squint, etc. then it's no good.
MOST people can do this fine with any dot, and minor variations between them are nitpicks, drive lots of people to either indecision or abandoning the idea. Around... 10-20% of the population (especially as we age) will have issues and cannot use all RDS as well as others.
...you have to break the desire to center the dot in the window in order to fire. If the dot is anywhere in the window and on your target, you are aimed...
For handgun ranges this is 100% true but SOMEONE is going to drive by and say parallax is not perfect across the window. True. Does. Not. Matter. I can go into great detail, but these are fractions of an moa and anyone that shoots their handgun to 1/4 moa probably also can center their dot in the window
...Going to RDS adds cost and new training and practice requirements, but for me it has been well worth it.
What I always say about the RDS transition is it just makes you focus on all the things you have been doing wrong. The transition to looking ever so slightly higher, looking at the target and the dot vs the front sight, etc. can be pretty well along very rapidly. Getting it all to come together like you are fresh out of a class is harder.
One good way IS to take a class. Dot up a gun you otherwise know, then take a respectable multiple day pistol class with it.
My way was to get a cheap chinese RDS and badly bolt it to a SIRT (laser trainer) and click around the house (and hotel rooms, I was traveling a lot at the time) to get a few thousand presentations and trigger presses. I'd devote a lot of time to safe dry fire, to airsoft or laser training, or if that is your way to first get a relatively cheaper one and stick it on your favorite .22 trainer, burn a brick of those while your centerfire is off at the machinist or you think of which dot to put on the dot-ready gun you buy.