SCART gets my vote for most annoying and unnecessary cable ever designed. Impossible to plug-in by feel, so you have to turn your TV upside down to plug it in; and massive too, I mean, does it really have to be that big? It is the Duplo of cables.
(I know it provides much superior picture quality to RF, but doesn't composite video tick that box as well?)