Low end model https://www.dpreview.com/products/sony/compacts/sony_dscqx10
High end model https://www.dpreview.com/reviews/sony-cybershot-dsc-qx100
Sony has consistently been innovating in this space but has always had basically insignificant market share. People keep complaining about mundane updates and AI crap but they won't buy phones from the one manufacturer that bucks this trend. MKBHD has a couple of videos about it (regarding the Xperia 1vi iirc).
My Sony phone has a 4k 120hz oled screen, notification led, headphone jack, fully manual camera mode, no bloatware or ai crap, great battery life (never had to charge my phone during the day). They had the battery save features years before other manufacturers. They've been doing this consistently for years. I don't know how they keep doing it, but I'm glad they do.
Most users would want to use the screen of their smartphone as a viewfinder. That either means using both hands or requiring a way to attach the thing to the smartphone.
Also, to do the image processing, that cylinder would need to have most of the processing power of the iPhone and, thus, a fairly large battery.