I find that my Sony RX100 produces better photos than my Pixel phone. It has an auto mode that generally picks the right settings.
The pictures are more detailed and less blurry, especially in low light.
The only post processing necessary is copying the pictures from the SD card, which is admittedly a pretty big hassle.
You’re right about buying one second hand, since they’re incredibly expensive.
The SD card? I have to track down my SD card reader, copy the pictures over, and then upload them to my photo service. It’s not a huge amount of work, but I’m pretty lazy.
My rx100 doesn’t have Wi-Fi. I assume newer cameras would do that automatically, but I don’t want to spend $600+ to get another good point n shoot.