Hello. I have achieved excellent results with Monster Cable M1000 series video cables in both composite and S versions. The Monster wire is relatively inexpensive, and well made. You can pay much more for expensive, esoteric wire configurations, but you won't get much more for your money in the way of improved picture quality.
