Taking a low-light firearms course was most enlightening (so to speak). Whether or not you use a light depends on a lot of factors. In our home, if other people besides my wife are here I would use a light to make sure of my target. If not, and she is laying next to me, whoever is in the house shouldn't be there.
I do like night sights and have them on my primary carry sidearm, but not any other as of yet. I also have an inexpensive light for my XD rail I got more for training than anything. It would have its purposes in certain places I spend time but I would be unlikely to use it at my current residence.
One of the most profound lessons of the class was that in any conditions much darker than dusk, those night sights only matter for the first shot. After that, the muzzle flash has destroyed your night vision and you are using "instinctual shooting" aka point and shoot for the next rounds in a string. However, after shooting that string, the night sights do allow you to more quickly regain the ability to sight on a target for many people. Of the several classes I have taken, the low-light class was probably the most eye-opening and assumption dispelling class I have had. I try to get some low-light shooting in at least annually when I visit our family "farm".