I've got to disagree with that assessment. It sounds as though you're just not very familiar with the SCD library. Now, obviously it's not God's gift to gaming, but there were over 200 games released for it. And while it certainly had its share of chud, there are many great titles for it as well.
It was an under the radar system for years that had its fans, but sometime in the late 00s or so, it became a meme of sorts. Which is rather unfair, considering the glutton of failed consoles from that era. And while you mention the 32x, the SCD was out over 2 years before the 32x which came out about the same time as the Japanese launch of the Saturn. I think at least part of the reason the modern SCD hate has become the norm is likely due to the unfavorable AVGN video from that era, but it really does seem as though much of the modern internet/YT gaming community unfairly craps on the SCD. In my opinion, anyway.
Off the top of my head, here are a number of games that I believe make it a system worth owning for those who enjoy the 16-bit era of gaming, but there are surely more, and of course, ymmv.
Snatcher
Robo Aleste
Final Fight CD
Lunar 1 & 2
Android Assault
Earthworm Jim Special Edition
Road Avenger
Lords of Thunder
Soul Star
The Terminator
Shining Force CD
Thunderhawk/Thunderstrike
Popful Mail
Dark Wizard
Rise of the Dragon
Spiderman vs the Kingpin
Vay
Keio Flying Squadron
Batman Returns (exclusive 3D driving/flying stages)
Cliffhanger (exclusive 3D snowboarding stages)
Best ports of Pitfall Mayan Adventure, Mickey Mania, BC Racers