In low light all of the dot sights I've tried were so bad optically that I couldn't see what I was shooting at. Seeing the dot does no good if you can't see where to put it. A conventional scope does much better in low light even with the small front objective as long as you don't go over 3X or 4X magnification.
If having a dot is important to you, they make some with a red illuminated reticle. You get the best of both worlds.
I'm not up to speed on exactly what I'd recommend at the moment. But that is the direction I'd be looking.
You dont have to "see thru" the red dots to shoot them. The first dot sights I had were OEG's and you couldnt see through the sight and had to shoot with both eyes open. Your strong eye sees the dot, your weak eye sees the target and your brain does the rest.
The OEG's used a FO "day" sight with a tritium night sight. Problem with them was, the transition really sucked, and your eyes needed to be fully adjusted to the dark to see the tritium dots. Going back and forth from light to dark didnt work well either.
To this day, I still use that method with the guns I have handy, and have the front covers closed on the Aimpoints. The dot is set at a comfortable "darkness" level, and I dont have to mess with the brightness when going from dark to light and back. Its also quick and natural to shoot with as well.
If you want a bit more precision, you can open the front cover and dial the dot to the brightness you want, but generally, the lower the power, the smaller the dot. Its just harder in bright light to see it, especially quickly.
I have a couple of Vortex 1x8 Strike Eagles now, and they have lit reticles, and work just like a red dot in some respects, including closing the front covers. Ive never really been a scope person, but with my eyes starting to go, they are starting to grow on me. I still prefer the red dots over them though.