In the 90s, early 2000's, there was a resurgence of the SID music scene that may not be widely acknowledged. During this time, new SID editors/players and techniques were developed, introducing a fresh sonic landscape with previously unheard sounds coming from the SID chip. Here's a few of my favorites from this era:

https://deepsid.chordian.net/?file=/MUSICIANS/C/Carlos_Breez...

https://deepsid.chordian.net/?file=/MUSICIANS/F/Fanta/Bombs_...

https://deepsid.chordian.net/?file=/MUSICIANS/J/Jeff/Svend_D...

https://deepsid.chordian.net/?file=/MUSICIANS/M/Mitch_and_Da...

https://deepsid.chordian.net/?file=/MUSICIANS/M/Mitch_and_Da...

https://deepsid.chordian.net/?file=/MUSICIANS/P/Peet/Harvy.s...

https://deepsid.chordian.net/?file=/MUSICIANS/T/Taki/Reynbow...

https://deepsid.chordian.net/?file=/MUSICIANS/F/Fanta/Challe...

https://deepsid.chordian.net/?file=/MUSICIANS/D/Dr_Voice/Sit...

https://deepsid.chordian.net/?file=/MUSICIANS/J/Jeff/Rectumo...

https://deepsid.chordian.net/?file=/MUSICIANS/M/Mitch_and_Da...

https://deepsid.chordian.net/?file=/MUSICIANS/B/Blues_Muz/Sp...

https://deepsid.chordian.net/?file=/MUSICIANS/D/DRAX/KickAss...

https://deepsid.chordian.net/?file=/MUSICIANS/T/Tjelta_Geir/...

https://deepsid.chordian.net/?file=/MUSICIANS/G/Greg/Magyar_...

https://deepsid.chordian.net/?file=/MUSICIANS/D/Dr_Voice/Yea...

https://deepsid.chordian.net/?file=/MUSICIANS/B/Behdad_Arman...

https://deepsid.chordian.net/?file=/MUSICIANS/D/DaFunk/Art_o...

https://deepsid.chordian.net/?file=/MUSICIANS/T/The_Syndrom/...

https://deepsid.chordian.net/?file=/MUSICIANS/B/Bakewell_Dwa...

https://deepsid.chordian.net/?file=/MUSICIANS/M/Merken_Vince...

I had to restrain myself from posting more, but I believe these examples will give you an idea. The C64 demoscene is still very much alive, by the way, with great SID tunes being released even today.