Excellent discussion. It's the Art and Science of photography. As I became relatively competent with the Science part, I started focusing on the Art and it took me down a completely different path. On the surface, what makes a good photo is lines, shapes, form, color, texture, composition, lighting, how to set a mood and tell a story. Easy, right, but you post what you think is a good photo and you get few or no likes, or worse, harsh criticism, why?
A photo is a transaction between the photographer's work and the viewer. Viewers are a huge random variable. An image that resonates with one group may actually offend another group, yet there are some iconic images that are universally liked. For example, a lone tree on hill as the sun sets or with the moon in the background. A happy child or children playing, ... When taking a Psyc class we read a research paper studying the differences between men and women. A series of photos with a wide variety of subjects were shown to the participants who were asked to rate the photos. The only photo both men and women liked was picture of a pretty young mom holding a baby. It turns out the men liked the mom and the girls liked the baby. Did you know that in addition to red, green, and blue cones, women have cones that are sensitive to orange? So viewers don't even see the same way.
Sometimes I take snapshots to remember a place or event, but that's not the topic of this post. I came to the conclusion that I will capture images of subjects I like, that I find interesting. Do a competent job technically with the camera, and a competent job in Post. Different photographers find different things that are interesting. Some like, shapes, form and texture, but I like very colorful subjects and I love a beautiful flesh tone. I love photographing animals, especially water birds. If others like them - fine, if not, I don't care. Certainly, I don't change my photos to satisfy photographers on social media who think photography is about their cameras and glass. Cameras and glass are tools, not photography. Photographers have taken phenomenal images over the years with far less capable cameras than we have access to today. While I have a Z9, I am not at a disadvantage with my D7200 doing street photography.
If you want to become a better photographer, follow Alex Kilbee on youtube:
https://www.youtube.com/@ThePhotographicEye He does not talk about gear, he talks about the Art of Photography.