As stated, the Sega CD has enough good games to make it worth owning.
I love Earthworm Jim on it. Always liked the game but on the SCD it's even better, and the revamped music is fantastic.
For the longest time I used to use a Model 1 SCD with one of those clone Mega Drives (Scorpion).
Worked really well.