But then again the N64 has not aged quite as well and tends to look like crap on any modern display

Super clear video display

but you may notice it on modern digital displays

Second, I've noticed some games have some slight graphical glitches when run in S-video (for example, faint flickering).

This is the cheapest legit S-video cable if you don't wanna fork out $70-100 for a Monster brand one & s-video is the best quality picture you'll get on your HDTV if you aren't wanting to spend $250-300 on a rare Gamecube component cable.

If you are looking for a good S-video cable, look elsewhere

my 36" HD CRT looks incredible, this is one of the few dedicated s-Video cables you can buy for the SNES/N64/Gamecube and it's well worth it if you have an S-video ready TV

good cables s video looks so much better than composite for retro games