I had one of the first Sig P228 autos in the U.S. I was in my early 30s with 20/12 eyesight.
I worked for a high-threat security firm that trained us under many circumstances, including varying degrees of low light into complete darkness.
As others here have said, shooting at a target that cannot be identified is a no-no. Night sights don't help much with that for the obvious reason that they do not illuminate the target.

In low light when it might not be possible to identify a target, it was possible to keep the sights IN sight and aligned while holding the gun out of alignment with my eyes, such as low ready. I was able to bring the gun into alignment quicker that way, and it significantly reduced the time to get on the target when it could be identified.

I am certain they aided alignment in low light as compared to black sights or even white dot sights.

I subsequently installed them on any carry/duty gun I owned or that was issued to me.

I consider them well worth the money.