Why can't we see in low light if staring long enough?
For simplicity's sake, let's really reduce this to something like photography.

A camera's aperture can stay open indefinitely, allowing the plate (or whatever is receiving and recording light) to "collect and save the effect of photons" over time, if you want to phrase it that way. That allows a camera to make images that our eyes never can, for example, of "star trails".



The retina isn't like a photographic plate or a digital sensor's photosites (or pixels). It can't "collect and save" like a camera can. There is a "refresh rate", if you will, that disallows a collection and saving of light that doesn't apply to cameras, because cameras don't care if something in their vicinity is sneaking up on them and presenting a danger to their lives. Not being able to detect change rapidly is something that would be most inconvenient to survival.


  It is the time sampling with long exposures that really makes the magic of digital astrophotography possible. A digital sensor's true power comes from its ability to integrate, or collect, photons over much longer time periods than the eye. This is why we can record details in long exposures that are invisible to the eye, even through a large telescope.


How Digital Cameras Work