"Can you zoom in to this teeny tiny spot on this photo and sharpen it like how they do it in CSI?"
OR
"You can uncensor this, yeah?"

Yeah let me poop out the winning lottery numbers while I poop out nonexistent pixels for you.

Well, wasn’t google trying something like that.

Using statistics for similar images to “sharpen” an image.

Of cause, its not actually showing the real target for the image but as far as I understand it would look very much like the movies and could be used to fix bad images when you do not need perfect match but just a nice picture :)

This looks quite cool and useful in some cases https://theinpaint.com/inpaint-how-... Looks like there is a red house that completely disappeares after "uncencoring", though.

Also, some images files hold a thumbnail of the original image, which can stay intact even if you modify the actual image.

I used to think it was impossible, but provided you are not looking at it from a 100% accurate standpoint, deep learning, specifically auto-encoders have come a long way in data generation for things like boosting image resolution substantially, to the point you could literally "zoom and enhance" just wouldn't be valid for use in any legal matters. Also people have taught these types of networks to "remove" censoring. I've not done any deep dives into these types of networks myself but from the data I've seen in regards to the points you've mentioned, the results have been quite impressive.