I LIKE RED DOT SIGHTS.............Get the best, Trijicon RMR. If any have failed in normal use I've not heard of it and many have with stood serious torture tests. Not saying they can't, just saying it is REALLY rare. There are several 'smiths who will mill your slide to mount a Red Dot on your pistol. You want it close to the bore axis.
OR........you could just build another top end for your current pistol. Remsport/TR Enabling will provide the slide already cut to the sight of your choice, and several parts suppliers will furnish the rest. I've built two new top ends for a couple of my Colts that I wanted to keep the original slides for.
Like you I suffer from "old eyes" and after tritium fronts and fiber optic fronts I finally went to Red Dots. There is a learning curve but once you master the proper grip/presentation, you'll always find the dot and two eyes open with target focus is just what my eyes needed. Don't try fixed sight cuts and mounts as they put the sight too high. Also stay with one gun type (1911 or whatever your favorite is). Changing grip styles/angles will only lead to frustration when learning Red Dots.
As always, JMHO
TR