If the answer were very simple, the entire lecture would probably not be related to the given issue. In order to answer the most frequently asked question, what kind of astrophotographer can get, we need to learn the principles of camera operation, explore the limits of the human eye, or look at the image processing itself.
In this lecture you will learn about electromagnetic radiation, the visible spectrum, the physics of the human eye and the camera sensor.
The answer, which will probably surprise you, will be based not only on physical foundations, but also on a philosophical perception of the world.