I think scart is great. It combined everything (audio/video) into the one cable long before HDMI ever came into existence.
There are more devices that utilise an RGB scart connection other than retro consoles. VCR's, DVD players, digital receivers, Foxtel etc.
Scart isn't big in my country (Australia), in fact, most people don't even know what it is. That said, you can still buy a TV with a scart input in Australia, even the new ones.