Ha, when watching those shows, I am always the nerd telling my wife how it's impossible to zoom in and enhance, because you can't create more information than existed when the photo was taken. I'm not sure that she gets it.
If machine learning is brought into play it gets even more interesting. See eg. waifu2x, the anime video upscaler based on Deep Convolutional Neural Networks. Basically it is a neural net, that has been shown A LOT of anime, and it can therefore creatively(?) fill in the created pixels when upscaling.
I have no idea how advanced this kind of ML boosted "enhance" technology can get in the future, and it might even get a little scary: imagine an observer with the experience of million lives spent looking blurry images in poor lighting. It might get surprisingly good at that...