Personally, Im not a big fan of micro-adjustable sights on handguns. The "fixed" versions work fine for me, as long as they can be zeroed for what I want/need.
That said, "pinpoint" accuracy is still pretty good with night sights (fixed or otherwise) and thats in "all" light, not just darkness. Thats the big advantage to them over unlit sights. They work in any light and against most any background. You always have something to use to get a more or less precise POA.
Another secondary advantage with the three-dot type is when used with a suppressor. You dont need the larger suppressor type sights to "see over", as you can "shoot through" the suppressor using the three dot alignment. And they dont even have to be night sights to do this. Anything with something that can give you a clear, vertical and horizonal alignment witll do.