I took these 2 pictures below recently on my Pixel 6 Pro using my rear lens around 8:30pm-9pm:
Without night sight mode enabled:
With night sight mode enabled:
Without night sight mode enabled:
With night sight mode enabled:
I’ve used night sight mode in even darker times, and it still is impressive!
This was a picture I took of myself around 6:30pm or so that day using my front camera and night sight mode. As you can probably tell, I like my rear cameras more.
It was a little awkward to take a selfie of myself with my rear camera, but as you can tell in the first post in this thread, it definitely makes a difference.