Need reco for Nvidia AGP for bigscreen TV

Gang
I need to get smart fast on what to buy. I want an AGP video card that will handle both a 26" LCD/TV [probably sharp] that has several types of inputs: the medusa thing, S-video, and regular coax/cable. AND I also want to be able to attach to any ole VGA flat-panel LCD monitor.

Are the typical GeForce 6 series cards able to handle these connections? What advantage is there, if any, to a "digital" card that has only the one strange connector [I don't know what its called but apparently it cannot work with normal VGA interface]

Do you give up much definition with the simpler S-Video to the big screen, VGA out to the small monitor?

Thanks! I need to go shopping....

z