Sure there will be many other differences in features and specs, but for the most part they pretty much do everything we need these days and for one who replaces a dedicated camera more often / always with a mobile the more important are the overall improvements on camera usage that therefore become the deciding factor (unless again you care more about gaming, stylus, etc ).
I know Google has the upper hand with software capabilities to make up for some of the lower hardware specs, very impressive, if only we could use if on other mobile phones.
Interesting insight with the sweet spot of x5 telephoto, as indeed not only zoom or bokeh/DOF is nice but also framing indeed.
I hope that the OnePlus 12 may beat the Pixel 8 Pro, but they have less camera software experience and fine-tuning compared to Samsung and Google. But can provide better hardware than S24 Ultra for much less money.