So, EU Night Vision (achievement-friendly) allows you to see everything clearly, even without a torch or sunlight.

In the image, there is a comparison between someone using the Night Vision add-on and someone who is not.
As you can see, this add-on works very well.

There is also an unedited in-game screenshot below if you are still not convinced.

SCREENSHOTS