Forget all the gold plated 'dangle berries', you won't see the difference between them and a £2.99 piece of rubbish.
As far as the "phono's" go, I'm guessing you are talking the yellow, red & white.
The yellow is composite video, and that is the lowest lifeform of all as far as analogue leads go.
A SCART lead that is wired for RGB is better, with component video (red, green, and blue phono's) being about the best you will get as far as analogue goes.
Note that not all SCART leads will be wired for RGB, some are so cheap that they are wired for composite video only (along with the audio of course).
You want to match the metal between plug and socket. So if telly is gold plated, use gold plated. If the telly is tin plated, use tin etc.
Its an analogue signal, so poor quality cables will degrade signal. And with any signal, quality screening helps.
Hence, I don't use cheapo hong kong ebay nasties. But then, I agree, I don't use the stupid, over marketed, over hyped, tosh either.
With all due respect TB, numerous "Which" magazines (eg, TV, Hi-Fi, etc) have conducted god knows how many tests using god knows how many cables, and the universal opinion is that the average home user is not going to see a difference between a SCART lead costing £5.99 and a SCART lead that boasts pure gold, oxygen free, etc that costs £70.
As the original question relates to a console that only outputs in analogue, any cable costing more than £10 tops is a waste of money IMO.
I was actually agreeing with you! The only thing worth doing, as said, is matching the metals so as to keep the connection good (dissimilar metals and analogue is a bad combination given time). You can get decent, cheap gold plated connected cables for similar money to decent, cheap tin ones

I reckon worth spending a little extra on decently shielded cables, but then behind my telly is probably a bit hostile - hdmi, video console cables, mce, gigabit cables, in addition to all the usual vga, component, scart, spd/if etc.