I used to be on a quest for the go-to camera that consistently produced 'better' shots than all the other cameras. 50 years later, there is literally zero correlation between my favorite shots and the cameras employed for them. Film, DSLR, mirrorless, iPhone.
Obviously, you aren't going to get a great shot of the craters on the moon with a disposable point/shoot 35mm film camera, but if you have the right tool for the job, you can get a great shot regardless of how 'modern' it is.
Most successful shot I had on Flickr last year was a shot of bison on the prairie taken with a 21 year old DSLR with a kit lens. For that particular shot, pretty much any camera would've nailed it. Slow moving subject, no need for shallow depth of field. Easy to focus subject. I dragged out the old Canon camera because I thought it would be fun – and it was!
View attachment 298656