I wholeheartedly agree with Blaze's statement. I have always felt that great photos can be taken with pretty much any old camera because the "greatness" is in the eye of the photographer, and the subject matter. How many of us will pass a day without seeing anything worthy of taking a photo. The person with the keen eye will see and capture dozens simply because they "see" so much more.
I have probably had only three "special" moments in this respect. As a kid I took a quick shot of my dog running in the garden. The result showed a slightly blurred running dog with a tail so long it appeared to be several feet long to a point where it was coiled around the outside tap on the wall.

The second was just a chance moment in the garden when a clump of water lilly floated past on the slow running river with a flower in full glorious bloom. I snapped it quickly as it passed into the sun. The third moment was when I was just wandering along the water's edge at a boatyard I was visiting. I glanced down to see a pile of ancient rusty chain lying on the pebbles. It must have been there for many years. So much texture and colour it was fascinating. I went back the next day with a camera but someone had removed it to have a tidy up.
Similar to
Spectrum, I started with a Brownie 127, then a Polaroid, then a large selection of Olympus OM10 + lenses, etc. When I moved onto the boat it was too bulky so downsized to a cheapo Fuji digital that was rubbish. My OH gave me a Sony that I'm really happy with. One day when I can properly retire I will see what it can really do.