Don't go out buying cables until you have a gander around the back of your TV (and of course your PC/laptop). There's no cover all solution unfortunately - Too many variables.

First things first, avoid S-Video like the plague. The digital video signal is converted to analogue...and badly. Not ideal for digital art.

Component is better. While it's still analogue, the quality is far better due in no small part to colour channels being split (Red Green Blue). You just don't see Component out on many video cards.

Ultimatley, as mentioned above, DVI is what you'll want for a sharp picture.

If we can hit that bullseye, the rest of the dominos will fall like a house of cards...checkmate!