On an RGB monitor (I have a Sony PVM-2530) you will see an improvement in RGB versus S-video. It is most evident with a Sega Genesis, but also with a model 1 SNES.

The XRGB-3's claim to fame is that it allows you to use a modern HDTV while maintaining an image resembling what we rmember from playing on a CRT.