I've had a bit of experience with extending VGA cables, and in my opinion, if you have your dislpay set at anything over 1280 x 1024 - or including if you're extending the cable 5 metres or more, there is a noticeable degradation. It'll probably look like "ghosting" - a faint version of the image on display, shifted by a few pixels. Or your dislay will be smudgy, loosing definition on things like detailed pictures where colour changes are close to each other.
On to the crisp display comment from Krieger, I'm using a 21" sony multiscan E500, trinitron flat screen. It is a nice crisp display, and any trinitron tube is going to be better than a normal tube of the same dimensions because of the way the tube's built. If you look closely at a non trinitron tube, you can see the phosphor dots that the screen is made up of. They're round in shape, and have a shadow mask / aperture grille that lets the electrons through in round "bunches". Now, if you look at a trinitron tube, the phosphor dots are rectangular in shape, and because they're squarer, they fit together better than round dots. Because they fit together better, there's less shadow mask and more phosphor dot area for the elctrons to hit, resulting in a better contrast, and sharper pixels with more defined edges, as pxels are square anyway after the video card sends them. However, you don't get a free lunch for nothing, and if you look about 1/3 and 2/3 the way down your trinitron screens, you'll see two very faint lines, where there are wires to hold the shadow mask in place, because the more precise shadow mask is weaker and needs support.
You'd probably need a 19" monitor to notice the difference, but I'd go with BNC connectors if you wanted a decent crisp display, whether you had a trinitron or not. It might depend more on the quality of the monitor though.