Changed the post title some.
Kudos on not wanting to be just "good enough" (code word for being accepting of crap).
The audio is always RCA, so let's sideline that. That's the red/white wires.
The video should all be s-video. Swapping back and forth between s-video and composite is just as bad as 100% composite. Composite was yellow. Now you don't use yellow. Use the black s-video cable, using s-video connections.
RCA = audio
composite = video
I know a lot of people use them interchangeably, but that's wrong, and why folks get confused.
Question is, does all your video hardware have s-video connection?