Sample CDs are not really compatible with any "synthesizer." However, there are some synths that can load, record and edit samples and that synth with sample features would need a CDRom. You can however, use your computer as a central location/library for your CD samples and load the files as WAVs into your synth with sample features or sampler.
A Triton can do that. I'm not sure about the Motif or VSynth or Fantom, but I believe they have similar sampling/sampler features... the Kurzweils also do.
Oh yeah. There is software for your computer that reads almost all of the major CD formats and can convert those sounds to WAvs for use in your computer sound library.
If your budget is on the low end, there are a few older samplers with some strong synth features that you may wanna check out. You can even fidn them used for a decent price.
The ASR10 has some strong synth features. The Akai and Emu samplers are awesome in my opinion and have a huge sample CD selection from lots of sound makers and distributors.
Good luck.