I ordered this one for $6.99 and it works fine. Not a referral link. Cable would work on NTSC SNES, N64 and GameCube.
Comparison between Nintendo Composite and that cable on a 20" PVM: https://imgur.com/g1GVptB
I took those pics 15 minutes ago. Images are not zoomed in, I was really standing that close. Reason why S-Video is much better is you can make out the individual pixels versus blurry Composite mess and the cheap $6.99 accomplishes that.
Is there a $15-20 S-Video cable that looks a little better? Wouldn't surprise me but this still 100% better than Composite.
I ordered S-Video cables off Amazon, then later got the Retrotink 2X-pro. For this, the S-Video cables were an extra add-on, but since I had heard the Retrotink ones were clean and good quality I purchased them.
Upon delivery, I was very amused to see that the Retrotink Cables were identical to the set I had ordered from Amazon.
https://www.amazon.com/gp/product/B000P6R46W/
These are the exact ones I ordered. If you order a different set, make sure it does NOT have the yellow composite cable. It should only have S-Video and the two Audio Connections.