I've gone back and forth on this over the years. I've done a considerable amount of training for night and low-light shooting, and so developed somewhat of a fondness for bright night-sights, because they do work for me if I'm not using a WML or hand-held light -- I think night-sights are best for low light situations where you have some ambient light, don't really need a flashlight, but it's dim enough that you wouldn't be able to pick up your sights really well without that nice tritium glow...
Also, for those of us that live without children or addition people in our household, isn't it comforting when you wake in the middle of the night for that bathroom call, to see those three glowing dots on your pistol sitting on your nightstand on top of your Holy Bible and the latest copies of American Rifleman and Field and Stream? One time, some years ago (prior to moving to my new more rural location), that nice glow helped me quickly find my pistol when suddenly awakened at night by loud crashing in the alley between my house and the neighbor's. Yeah, it was a pretty militant raccoon, but I was ready.
I'm kind of of the belief that private citizens don't really need WMLs -- unless they've acquired some good training in their use. Otherwise, too much potential for inadvertent Rule 2 violations (it's simply too instinctive to point the light, hence the muzzle as well, directly in the direction one is trying to illuminate). And frankly, I'm getting kinda down on WMLs for patrol officers as well -- not everything you are illuminating, or need to illuminate, is a target. I've seen a lot of bad muzzle discipline and don't think every building clearing requires one to unholster one's pistol to use its light.
As far as choosing between the added expense of night sights on one's new pistol or a quality SureFire, Streamlight, Fenix or O-Light -- even the non-gun person should have a top-quality flashlight to keep on their person at all times. Plus, many companies now (SIG and Kimber to name a couple) offer really nice night-sights on most of their pistol lines, at really no extra cost.
With regard to night-sights, to me, just another thing I'd rather have and maybe never need, than not have and then just once, really need. So my answer to the original question is, yeah, night sights are worth it for me. (And for those that may not agree, I have no problem with opposing views on this subject)