For me, the attraction was the potential of breeching the then-seemingly impenetrable wall between my computer and TVs. I had recently come into the possession of a CD burner (DVD burners were not yet available, at least not cheaply) and when my family picked up a dedicated DVD player that was advertised as also handling VCDs, I saw an opportunity.
The associated software ecosystem was quite flaky, though. I tried burning them with Roxio Toast and Nero among other utilities, but producing VCDs that player would actually play was hit or miss. I burned several coasters and eventually gave up.
Seeing content created on my computer actually play on a TV really felt like a miracle in the 90s.