I don't understand why night sights or adjustable rear sight is determining you being able to "rely" on that weapon.
You will not use it in a defensive situation exceeding 10 yards. The Sigma platform is stone cold reliable and more than accurate for self defense range and further if you do your part.
Fixed sight handguns usually are point of aim at 25 yards. If you can keep every round in a 7 inch paper plate at 10 yards it's combat accuracy is more than acceptable.
Adjustable sights do not correct bad shooting habits. I have over 4000 rounds through a SW9VE in the last two years. The original purchaser couldn't hit a barn if he was standing inside it.
He didn't even try more than 2 full mags through it when he deemed it a piece of junk...bad sights,bad trigger..yada yada yada.
I will tell you that ammo does make the difference. Depending on the grain, yours may shoot higher or lower at specific distance. My 9 is most accurate with 115gr fmj or hollow points and is superbly accurate with 115 +P HP's.
Learn your gun stock out of the box...you may find that you shoot it better than you think. It's combat accuracy is well within acceptable limits.