I seem to remember reading that they were far more popular in Asia. There were add-ons for the PlayStation and the Saturn to be able to play them.
The only time I ever remember seeing them were on a spinning bargain rack thing at the front of CompUSA in the mid to late 90s with things I had never heard of on them. I don’t remember what, maybe foreign movies or something.
The good thing is it was better quality than VHS and DVD while still using cheap CDR and it was readable by most DVD players.
The bad thing is you would only store ~30-40min in a single disc, so sometimes multiple discs were needed. But it was still significantly cheaper than buying a dvd recorder and DVDR medias.