I fully understand the home defense argument against the dot sights, and they make a lot of sense. Also folks are correct in my opinion that milling or a dedicated MOS style pistol are probably the best ways to secure the sight to the pistol for a few reasons...for the sake of argument I would say that a more secure mounting point and lower overall profile when mounted are primary reasons.
All of that aside, the sight you pick makes a big difference as well as far as ease of use and/or profile. In other words...if you don’t plan for the pistol to leave the home (and HD argument aside as mentioned above) then a larger optic window will ease target acquisition (DeltaPoint Pro, Vortex, or similar). These also tend to have more “clear” lenses. If your purpose is to carry, then toughness and overall size (versus weight, much less a factor) become important, and I personally believe that a Trijicon RMR fills that role best. The window is more “blue” and smaller, so these take more time to train well on, but the profile when mounted speaks for itself.
Lastly, if to be carried, it is likely you may need another holster to accommodate the optic, so keep that in mind as well.
I admit I thought them to be a bit of a gimmick at first...now I have two mounted to pistols...so ya. Lol