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.
Credit to HDMI, it finally standardized the IO systems that means PC to TV is trivial nowadays.
I eventually just gave up and watched things on my iMac G5 since its 20" screen wasn't all that much smaller than my CRT TV, and then later in college I upgraded to a 27" Intel iMac which had a nice IPS panel display and was better to watch things on than most flat panel TVs from that era around that size.