You might notice less ghosting in movies and games, depending on how anal you are about it. You should notice that text is sharper and clearer, anal or not. I notice both.
An analog input is designed for CRT monitors, and using an analog cable with a digital monitor (LCD) means the LCD has to convert the picture for you. A DVI signal is a direct, digital link between the screen and your VGA.