Long post warning.
This was going to be a reply to an earlier thread, however as the question comes up from time to time in photography discussions, I figured having direct comparisons would be of benefit to the community. That other thread was talking about telephoto (birds/wildlife) so that’s the example I’m using.
First off, I’m not comparing convenience, and I’m in no way rubbishing mobile phone cameras. They are ridiculously good, particularly given their on-paper specs, and in many situations they’re the better option if for no other reason than that you have it with you. With the many tricks they employ, from taking multiple shots and layering them for noise reduction, to simulated bokeh, auto-applied sky optimisations etc the point-and-shoot results are incredible. For a spur of the moment pic of friends, an interesting thing you see on the way home from work, making a note of something you’ve seen at the shops, taking a look at that thing behind the cupboard you can’t quite get your eyes at the right angle to see - they are unbeatable. A lot of people are just after pics to look back fondly on, which they might post up on social media where they’ll be heavily compressed and only seen on small screens by people who don’t know or care what SLR stands for. For those people, pics from a phone camera do the job just fine.
But for this post we’re talking about outright quality of the resulting image, and in that regard it’s important to acknowledge that phone cameras do have their limitations. Beefy processors and incredibly smart software can only do so much to get around the physics of short focal lengths and tiny sensors. There are reasons that National Geographic and ESPN aren’t saving themselves a fortune and just issuing their photographers with a phone.
I am not a professional, I won’t even claim to be particularly good, but I hope this is of some value to someone. And if not it was a good way to kill a bit of time on a rainy day.
So with all that out of the way - I was bored and thought I’d take a couple of example pictures. The weather was crap, and the pics are by no means showcasing anything special, but I’m hoping they’re enough to help visualise the difference between two devices that can do broadly the same job, but with wildly different compromises.
First up, pics from the Samsung Galaxy S23 Ultra. Not top of the pile I’m sure, but it’s what I have, and I’m comparing it against a body released a year earlier so I reckon it’s fair enough, particularly given the S23U was a flagship at the time and its camera was a marketing point. Aside from zoom and resolution I left the settings alone as that’s what the vast majority of users will do, and I dare say the defaults would give the best results anyway.
At 200MP. EXIF says it was at 6mm, ISO 10, f/1.7, 1/583s, though with the software trickery I’m not sure how comparable those figures are. Zoom isn’t available in this mode, this is a 1:1 crop:

At 50MP. EXIF suggests the same settings as above except 1/580s. As with 200MP there’s no zoom in this mode, another 1:1 crop:

And in its regular 12MP pixel binning mode, which does allow zooming, at 10x (its max optical zoom IIRC). These next few are full uncropped images, resized down for posting:

12MP at 30x, heavily software-assisted:

12MP at 100x, its max magnification:

For comparison, standing in the exact same spot, I took the pics below within a minute of the above. Canon R7, 70-200 f/2.8 IS USM Z + 2x TC. 400mm, 1/800, f/6.3, ISO 500. Near-zero processing effort has gone into this, just the auto-applied optical corrections and colour profile in DxO Photolab, then denoise and cropping/resizing for posting. It took longer to export and rename the files than to edit. And before it’s mentioned, yes I’m aware that apparently the TC does affect image quality, though in my experience it’s minimal, and there aren’t too many ways to get 400 5.6 without spending a fortune and/or losing versatility. That said if anyone wants to buy me a 400 f/2.8 I’d happily reshoot the photos!
Anyway, as shot, just resized for posting, showing the framing at 400mm (+ crop factor giving 640mm FF equiv):

Tighter framing (via cropping):

And a 1:1 crop of the main subject. It was windy af and the power line in front was moving quite a lot:

There you have it.
I’m sure someone can pick holes in my method but IMHO the difference is obvious. And if you read all the way down to the end, I hereby award you a virtual fist bump.
(Edit: text formatting)

The one difference, and the reason I bought an Olympus. If there’s a random pic to take, sure, the phone will do a good job. If I’m out to exclusively take pictures, I’d rather have a dedicated device. Because the phone battery will die.
The truth is that the smart phone is an everything device. It has to handle communications, navigation, payment, calling a taxi, or the public transport app. I can’t afford to have it die on me because I also took too many pictures. A power bank is a viable but annoying workaround. And that’s without mentioning the distracting doomscrolling lure they are.
Phones already do too much. Their batteries won’t afford them being anything exclusively. And a dedicated camera is more comfortable, tactile, agile, accurate than the candy bar phone format will ever be.