Here is my thinking as of mid June 2019.
For carry and hard core defensive use today, the RMR type 2 is the only high probability choice, unless an Aimpoint Micro works for your situation.
The RMS Shield is unproven, and leaving aside the current model is not waterproof and I know nothing about the new waterproof model, I am not aware of enough of them enduring high round counts to view them as viable.
The SRO clearly has teething problems, between the adjustments moving, and emitter problems experienced with multiple units even in our small sample. Hopefully it gets sorted out, but as of today, the SRO is at best, a “buy from Amazon” proposition, so you can return it for a no hassle credit, like my friend and I are doing.
The unmodified DP Pro is a real crap shoot. Some people report crazy high round counts, but my wife and I have broken 31 of them, making them hard to depend on. The three prototype ruggedized ones we have are working well, so with Leupold set to standardize those changes soon, the Pro may still be the gaming optic of choice.
The C-More RTS2 may be a niche gaming choice, but it doesn’t have universal mounting support, has less than ideal CS support for broken units, and I think is best on a frame mounted pistol.
The Vortex units seem to be hit and miss. I don’t know enough about the Burris and other lower end units to form an opinion.
The Acro is clearly an unknown. Aimpoint promised Aimpoint battery performance and reliability, and we know half that claim is wrong, so it remains to be seen on reliability, and whether it is overall viable. In any event it is harder to conceal, with a display to small for competition, making it a niche rather than universal solution.
A few months ago, I was convinced that 2019 was the year we finally got great new red dot choices that brought the PMO mainstream. Today, I think Aimpoint and Trijicon have snatched defeat from the jaws of victory with the SRO and Acro introductions, and realistically only after months of high round count use by multiple users, will we have an idea whether there is anything better than the RMR for defensive use and the DP Pro for competition.