Please don't take this the wrong way: nothing is a cureall, there's no magic wand, and anything can be an incremental benefit as long as it doesn't get in the way. I say those things only for the purpose of suggesting a way of thinking that doesn't seem to be common but might be interesting.
My own experience with night sights is that they come into their own only during brief periods of the day outdoors and under certain conditions indoors. Those times are when there's enough light to see the target but not quite enough to get good sight alignment and sight picture without work. Think twilight outdoors and dimly lit places indoors. Then the glow of night sights helps a lot for a situation that requires sighted shooting. In sunlight outdoors or in well illuminated places indoors night sights have little to no value for me. I also don't see any value to night sights in a hand-to-hand defensive situation no matter what the lighting conditions.
To summarize, if I know that I'll be attacked outdoors in sunshine, indoors in a well lighted room, or at a distance not much greater than three yards, I wouldn't spend the money on night sights. But if I know that I'll be attacked I wouldn't be there in the first place, so all other considerations--including night sights--would be a waste of time and money too.
All you get with night sights is a bit of an edge in certain limited situations. That edge is worth the money to me. It might not be worth it to you. You decide. Me, my desire to continue living is so strong that I'll explore and probably adopt anything that can give me an edge.
So I have night sights on every handgun I might carry. I also have detachable weaponlights when possible and I always carry a flashlight. The flashlight is habit, mainly, as is a pocket knife: it's what I've done since I was a young teenager and I feel naked without them.
For additional perspective, I have absolutely no intention of ever shooting anyone. I don't like hurting people and I absolutely do not want to end the life of someone else. I will do anything possible to avoid a deadly force situation. So my thinking is never about intention, always about preparation.
All the above is about me and my thoughts. None of it is a recommendation for anyone else.