This is just my opinion.. but I would not say you will see a huge difference. I had my dual lcd's on a 9800pro, one dvi and one analog, and I really couldn't see much of a difference.
I should note that my displays are not exactly top of the line, but their not junk either... I think if you have a really high quality display you will see more of a difference...
There is a visual difference. However how important that difference is is subjective. For me personally I think its important and spend the extra money on DVI. Though it also depends on the quality of your LCD your using it on.
One of the main reasons that DVI looks better is because it has one or two less DA conversions than a VGA interface would.