The battery operated RMRs are supposed to be really tough/durable/reliable. You have to remove them once a year to replace the battery so you'll need to hit the range and re-zero it after replacing the battery. Don't over torque the screws when reinstalling it. You don't want to strip out the screw or the threads in the slide.
The DP Pro is not supposed to be as tough/durable as the RMR. The battery does install from the top, so no need to remove the sight or re-zero it when you do replace the battery.
That new Holosun 507C (think that's the right number) is supposed to be tougher than the DP Pro. But not RMR tough.
I have two of the dual illuminated RMRs (no battery), the dot is powered by ambient light when there's enough, tritium when there's not enough ambient light. There are some issues with those depending on lighting conditions. If you are in a dim area and the target is in a well lighted area the dot can be damn difficult to see against the target. I lose the green one completely, the amber one is dim (for me) but still visible.
We also have two DP Pros. One on a CZ75 Compact and one on an AR15 pistol. Last time the batteries lasted a year before I replaced them. Reminds me, it's time for them to be replaced again. No issues with either one, so far. I put the DP Pro rear sight on the back of the DP Pro so my wife has back up sights, too.
I'm seriously considering one of those 507C's as a trial. Same "foot print" as the RMR.