VGA to single RCA

Composite video is analog and it doesn't have the resolution required for a VGA display. If you want your image to look like a crappy security camera then go ahead. Otherwise you are going to need a much more capable transmitter.

No you can't "zoom and enhance" like they do on TV.