I joke if it goes down means something happened to me but sometimes the server has a problem like running out of space since an error logger keeps writing over and over
At a minimum, you have demosaicing, dark frame subtraction, and some form of tone mapping just to produce anything you'd recognise as an photo. Then to produce a half-way acceptable image will involve denoising, sharpening, dewarping, chromatic aberration correction - and that just gets us up to what was normal at the turn of the millennium. Nowadays without automatic bracketing and stacking, digital image stabilisation, rolling shutter reduction, and much more, you're going to have pretty disappointing phone pics.
I suspect you're trying to draw a distinction with the older predictable techniques of turning sensor data into an image when compared to the modern impenetrable ones that can hallucinate. I know what you're getting at, but there's not really a clear point where one becomes the other. You can consider demosaicing and "super-res zoom" as both types of super-resolution technique intended to convert large amounts of raw sensor data into image that's closer to the ground truth. I've even seen some pretty crazy stuff introduced by an old fashioned Lanczos-resampling based demosaicing filter. Albeit, not Ryan Gosling[0].
Of course, if you don't like any of this, you can configure phones to produce RAW output, or even pick up a mirrorless, and take full control of the processing pipeline. I've been out of the photography world for a while so I'm probably out of date now, but I don't think DNGs can even store all of the raw data that is now used by Apple/Google in their image processing pipelines. Certainly, I never had much luck turning those RAW files into anything that looked good. Apple have ProRAW which I think is some sort of hybrid format but I don't really understand it.
[0] https://petapixel.com/2020/08/17/gigapixel-ai-accidentally-a...
conspiracy tangent, try to take a picture of something you're not supposed to and your phone won't let you ha, well money could be an example which I get the reason (it's printers but that idea)
If I'm taking a picture of something I want it to be real light-to-pixel action not some made up wambo-jambo