In the future hopefully more will use better security cameras. There are some great quality 1440p res cams available.
The image enhancement thing of that extreme nature is already being experimented with using neural networks, but obviously there's still guesswork involved by filling in detail it can't otherwise refine normally, eg:
In the above the faces are vaguely similar but different enough to be a completely different person, though when you think about things like police sketches it might actually be an improvement
So being able to get keys cut from the quality of the enhancement is far-fetched but other things maybe not so much.