I live in Europe and our first system was a modulator-less Atari ST, so we've been using RGB as the default basically forever and screaming in pain when forced to use Composite or, god forbid, RF.
PSX and PS2 games using RGB were awesomesauce. Composite dot crawl when having to use a cheaper cable was pretty rank.
At least, with the older TVs that was the case. Modern ones do SO much of a better job with 3D comb filters and the like that I can only definitely tell a difference with fine text (esp that with coloured text overlaying a background of essentially the same luma, or white-on-black at just the right font pitch to induce chromatic abberation type effects) or the most extreme of complementary colour borders. Certainly for most videos and most low-rez games it doesn't make a significant difference any more, so if I get a system that outputs composite I just RCA that shit up and forget about it.
RGB is still good for hooking up to old CRTs, mind.