Me and my girlfriend both own the Sony Xperia Z3, which had a cutting edge camera when it was new.
I upgraded to the Galaxy S9 a few months ago, she still has her Z3. The advancement in photos is striking. It's incredibly noticeable, especially the reaction time after pressing the button and the low light performance. To a point we explicitly use my phone to reshoot images we already did on the old phone, if we like the motive. I upgraded mostly because 16GB internal space wasn't enough for me anymore and Android keeps bloating. But if I had experienced the camera difference before, it would have been enough to make me upgrade.
From my non-professional perspective the only thing lacking to a real camera is optical zoom. Otherwise I'm positive many shots of the S9 turn out on par or even better than mid-level Canon/Nikon reflex camera shots, if taken at the right distance.
The camera market is getting more and more redudant for non-professional use cases.