Well, for the older systems, it really depends on the game. The picture tends to be slightly less muddy, but if the game itself doesn't support anything better than 480i it won't look much different.

I think All Xbox1 games support 480p, which tends to look crisper than 480i. I mentioned Soul Calibur 3, because I think that runs at 720p (like Soul Calibur 2 did on all systems), and I think Tekken 5 has an HD mode as well as Shadow of the Colossus. If a game has a Progressive Scan And Widescreen Mode, I will play it in that mode. If it doesn't have it, it doesn't bother me--but when I know a game is supposed to look good I do what I can to make it happen.

As for the cable I mentioned in the topic, I haven't used it yet. I just placed the order earlier. However, I mentioned I had a similar cable for my PS2/Xbox, this is it. Hardly the most high-end looking box :P but it worked perfectly. Halo 2 looked as great as it did on the Official Xbox Component Cables, and the few HD games on PS2 looked equally fine. I'm sure there are some differences between cables as far as quality goes, but I think those are more determinate by how they are handled. The highest quality cables could be durable enough to have vehicles run over them repeatedly, while a very low quality cable could snap just by bending it.