That's cool, I have been wondering about rotating video too, good to know.
In terms of enlarging pictures, you are unfortunately limited by the amount of information present. Suppose you have a picture of someone's office. There is a piece of paper on the desk that seems to have writing on it, but when you zoom in you just see the same grey blur, only larger. This is because the information is not actually saved in the picture, the picture only contains grey pixels of various shades. The computer cannot "make up" what it says, there just is not enough data to go on.
So, a 20kb JPG file is not going to look like much enlarged 100x.
The best I have found is IrfanView, which can use a Lanczos filter to enlarge a picture and it actually attempts to guess what is there. It does a pretty good job, but nothing like the unlimited zooming you see on TV - I'm guessing that is fictional. You can zoom in a fair bit if you are starting from an extremely large, high resolution image, but you are still limited by the detail of the picture that was actually taken.