My girl has an S24U and outside it is badass. Indoors, low light, it's really weak. We just bought a 13 year old Canon EOS (Rebel) and it takes much better photos inside. You can get some amazing bargains on old DSLRs.
* until you zoom in or look at it on a screen larger than you'd hold in your hand.
Seriously, even on a modern Pixel (mine) and iPhone (gf's), I'm often disappointed in the level of detail you find once you want to crop an image or zoom in on something distant/small.
The software has come a long way and does incredible things within the limitations of such tiny lenses and sensors. But I've got much lower resolution images from point and shoot cameras in the mid/late 2000's that show more detail and none of the weird software sharpening artifacts of a 20-40+ megapixel phone pic.
Pixel peeping is another story, but most people are looking at these things on the iphone screen itself or at most something ipad/laptop size. Its not like the old days where you went down to the basement with the slide projector and watched the vacation photos on a sheet.