If I were 25 years old again, with the 20/15 vision I used to have, I'd be the biggest fan of red dot sights ever. Even though I was great with the pitiful Government Model sights on the military 1911s.
These days, if you have any degree of astigmatism, worsening myopia or the beginnings of cataracts (in other words, you've developed "geezer eyes"), you already know that your night vision is suffering and the taillights of the cars in front of you when driving at night turn into huge blurry masses with halos or big blurry star clusters with rays shooting out. So shooting handguns or long guns with RDS optics can be even worse, with huge "starbursts" or just totally blurred out reticles.
For me, a HWS (i.e., EOTECH) or an ACOG presently works a lot better for me than an RDS or LPVO.
In natural day light if I'm not using a scope, iron sights, most especially aperture rear sights with a front sight post, are still the most effective sighting system for my failing eyes when shooting at distance (50 yards and beyond). In low light and darkness, an illuminated reticle can be helpful, depending on the type of optic and intensity.
All this said, in the last couple years before I retired, using an RDS (Leupold Deltapoint, then a Trijicon RMR) on the pistol for qualification during daytime at the outdoor range was very nice once I learned to get the pistol up, keep my chin up and ignore the iron sights. But I never shot substantially better than with iron sights, perhaps just a hair faster.
But yeah, with the way technology keeps developing, it's always the next big thing.