Keep in mind that allegedly not all American SNES revisions support RGB out. From what I understand, only the older models do. If you have something newer, unless it's a SNES2 (for which there is a
mod to restore RGB), the best you'll be able to get is s-video. Which isn't all that bad, really - it's much better than composite - but RGB is better. Though unfortunately s-video won't work with that CGA-to-VGA scaler without an extra device to transcode s-video to either RGB or component (not composite!); I'm not aware of any cost-effective ways to do so, and I'm assuming if you're considering the CGA scaler that cost is important to you...
If you're adventurous and have the right tools, you could open up your system and compare with the photos on the page describing the
S/PDIF mod. If yours looks like the "Older APU module", it should support RGB out. If you have the "Newer onboard APU", RGB
might work... I'm having a hard time finding a source of information on this. If you have the "last revision of the APU" (no pic given), your SNES won't support RGB as
discovered by kamiboy.
To save you the trouble of cracking it open,
look at your eject button. If the word "eject" is written in white, you have one of the early models, and RGB
should work. If it's the same colour as the rest of the button, but the text is molded on (that is to say, you can "feel" it) you have a newer model, and RGB may or may not work. If you don't have an eject button at all, you have a SNES2; see above link if you want something better than composite out and are willing to solder.