Goodness me, this looks like a very large question, unless you mean units which play _both_ SACD and CD. Personally, I can listen to classical piano or violin on any player at all. (The better players I've had do a better job, it's true.) As for dual players, I've had two Shanlings. Right now I have an SCD-S200 and it sounds wonderful on SACD and very good with CD.
If you could narrow down your question a bit--mention your budget and perhaps your associated gear--that would be helpful.