My childhood and teenage experiences with televisions were diverse, including Philips televisions from the 1970s or 1980s (assembled locally by EIC under the “AL-Qithara” brand). Most of my experiences with the Famicom (Clone) were with these televisions, of course, with RF connections.
The Sega Mega Drive was connected to a Panasonic television with a composite connection most of the time, and sometimes to a Philips (AL-Qithara) or even a small, old Sony via RF.
The PS1 was with a large 27-inch Sony (made in the 1980s, I think, and they were two televisions of the same size but completely different models) via composite, and often with a PAL color conversion (it use PS1 RGB as a base to PAL color reproduction).
The PS2 was also initially connected via composite, but later I tried RGB Scart with one of the big SONY televisions, and also I bought an LG television with a component connection (but I remember SONY with RGB Scart is better by a bit).
I can assure you that there are differences in every aspect between the connections and the TVs.
Of course, the Sony’s picture was the best in every way. The others weren’t bad, but the Sony was the clearest and sharpest, etc.
At the time, I didn’t know that the Sega Mega Drive could take advantage of the limitations of composite.
Fortunately, I didn’t use anything sharper than composite on the PS1 either.
Also, while there were clear differences between the connections I tried, the differences also depend on the TV itself in handling the connections.
I remember one time I went to my uncle’s house and my cousin was playing PS1 on a TV from a Korean company, I think (because they were popular at the time). I was blown away by the amount of dot crawling on it!
also, PAL seems play nice with composite video (and even RF) than ntsc, it’s better in colors and almost everything except the frame rate (there is PAL 60, that PS1 “PAL color conversion” will output as PAL 60 in every ntsc game)