A well made laser-aimer/CREE-white light would be a great add-on for many modern duty pistols.
I've read & heard of many T&E problems with the popular Crimsontrace & Lasermax systems.
For most uniform positions, I'd consider a large or mid size pistol(P226R/P229R or HK P2000 LEM or a PX4) with a powerful white light/green dot laser.
Many LE gear sources(Blackhawk, Safariland, Bianchi, etc) sell holsters that hold the lights/tactical lasers.
Low light places can occur nearly anywhere on any shift(day or night).