I managed to skim the entire thread without losing my mind, so I'll just toss out my personal experience. I have one red dot pistol, and I convinced our department to make the switch to red dots a little over a year ago. I don't find that my red dot is any faster inside of defensive distances like supermoto is talking about, but one of the reasons we went to them was to at least provide some kind of equal footing if an officer doesn't have time to get to their rifle to be able to shoot at distance. That being said, our qualification scores have gone up easily 25% since we switched to red dots. I'm the instructor.
The issues in the rain are real. I know everybody wants to be super right and have gear that has no flaws, but recognize it and move on. another issue that I have encountered, is going from an air conditioning car out into a humid environment. There has been two occasions where condensation fogged up my red dot. Fact. That doesn't mean I'm throwing out the baby with the bath water. Every tactic is a compromise.
I don't carry a red dot pistol off duty, but I do compete with it occasionally to keep skills up.