That sorting is pretty odd, and not really the thing for someone who doesn't know about the demoscene. For instance LFT's safe VSP demo was really high up. I understand why, it was a really important technical proof of concept and it explained something that had bothered demo coders for decades, but it's not a terribly interesting demo to watch. What impresses demo coders isn't necessarily the same that impresses the rest of us.
Some of my favorite classic demos are "Sound Vision" by Reflect, "Desert Dream" by Kefrens and "Enigma" by Phenomena. All demos that were popular enough in the 1990s that they reached me and my brother's Amiga by way of modems and swapping. They're all very enjoyable without knowing much about the coding challenges.
I'd say my favorite modern Amiga demo is "Eon" by The Black Lotus. For C64 the good modern demos are too many to count (and by comparison, the 80s era demos aren't terribly interesting), but I think maybe "Lunatico" by LFT is my favorite. Again it's one that doesn't require coding knowledge to appreciate.
This was always special to me, especially as a metalhead- they managed to capture the emotion of this song / part of the song so well, tech and style, fantastically combined.
Always love how they timed the surprising animation of the mask at the end (maybe face, don’t remember right now) too a smile in time with the emotional lift at the end of the song…
Gotta watch it later in full blast! :D thanks for reminding me!
One thing to keep in mind is that it's not just about the visuals, but about how they got those visuals to work with ridiculous limitations. As an example, "debris", the current top-ranked entry, has a total file size of 180kb and was released in 2007!
I mostly follow the PC scene, and I'd recommend checking out demos by Fairlight&CNCD, MFX, Kewlers, Orange, Still, Quite, Logicoma, and if you're into those then check out other groups that get 'greets' from these ones (a section of many demoscene productions where groups greet each other by name). Pretty much everything can be found on pouet.net.
Here's a YT link to one of my favourites: 'Number One Another One' by Fairlight and CNCD:
https://youtu.be/0CBQI7cktMk
https://youtu.be/N5CNlMGcARA
https://youtu.be/gKNvLyxHTmg
https://youtu.be/IFXIGHOElrE