I think that, like onions and ogres, Art has many layers.
For a start, I would concentrate in the overall composition, shape, feeling... on how it looks from afar.
Then, as you go on, that may be enough, and it is all good and well. No need for more.
Some years ago, I visited a monastery in the Way of St James, and found an amazing tromp d'oeil, where a painter monk had done this loose painting of a procession of monks in an atrium, nothing detailed, but as you moved, the whole line of monks and the building perspective seemed to move to always face you. That's one step farther than just two eyes that follow you. The artist had made a stunning piece without needing to care for any detail.
Or you may discover you delight in mastering detail, and start painstakingly working to get something that also looks great up close.
Once, in El Prado, I stopped ad realized someone was behind me (saw his hand), as I turned around to apologize I discovered the hand was from a painting of Goya (I think), it was so realistic it had fooled me.
Or maybe you do not like detail, but enjoy playing with the brush, or laying out paint, or building up textures... detail needs not be realism, could be many things.
Can't remember if it was in La Biennale di Venezia, or in ARCO international fair of Madrid, I was drifting by when an abstract work caught my eye from very far away. From that distance it didn't look different from so many others we had seen, yet it somehow caught my eye. I told my wife I needed to look at it closer, and from up close, I realized it had amazing 3D built-up paint textures, which you somehow couldn't consciously tell from afar, but which my eye unconsciously noticed and found so appealing. It was by a very well known contemporary painter and architect (which I generally like very much, but whose name now escapes me).
The point is that some works do not need detail to be amazing: many graffitti, murals, tromp d'oeils, in Bushwick, Brooklyn, NYC for example, ... do not need detail to be amazing, but some artists delight in taking it one step farther, and in playing with up-close detail. At many levels and for many reasons.
The last time I went to an itinerant exposition of Van Gogh, they had a minute 3D printed reproduction of one of his works (can't remember which either) which you could even touch, and up close, it was amazing to see how he had laid out the brush strokes. You know VG: not much realism, not much detail up close, but the brush work... oh my! One could make the image with blind eyes just by following the brush work.
I don't claim any of this artists intended these effects, most likely they just intended to get their overall painting right, letting their pet obsessions permeate their work unconsciously. But, up-close, that told you a lot about their seek for perfection, in different directions each.
So, not, no need to look great both close and at distance. But when it does, it adds up to the overall experience.