I was playing Burnout Legends in that video.
This is the cable I'm using:
http://www.amazon.com/gp/product/B0015S ... ss_productAll the connectors on it are gold plated.
Though, one thing to note when using the s-video/composite cable opposed to the component when playing games is that it does not scale the image up to fill your whole tv screen. It only displays at 432x272 resolution. And you know 480i appears as 640x480 resolution so basically you have black bars on the top and sides of the image. You can get around this if your tv has a zoom feature. In that video I had the video being cropped by FMLE.
Component on the other hand, uses the full screen.
You can't use composite/s-video for games at all unless you have a psp3000. There is a homebrew app that lets you, but from what ive read it doesn't look as good. I wouldn't be surprised if it doesn't work with every game either.
If you want to play emu's on the tv though you should get xbox1 and mod it. You can play pretty much every emulator on there before dreamcast.