I've found that SACD sounds better, in general, than does CD. However, SACD, like CD, depends entirely on the recording and how it was made. Unfortunately, many of those who are making the SACD simply give us the digitization from the CD, which limits its dynamic range and, as a result, no better. But, saves them the $5K it takes to go back and redigitize in DSD format (SACD) from the master tape. Think as a result this is killing the hi-rez formats. Why buy the equipment and pay more if the folks doing the recording don't care enough to do it right?
BTW, I am heard (read) a nasty rumor that Sony is going to let SACD die. Not going to sub-license, etc. Just going to let it go away. Glad I only sprang for a dozen SACDs. Most of them sound better. But, overall, it is the failure of those that supply the SACDs to record them properly that has resulted in its failure.
SACD is better than CD when done right, but still can't touch vinyl. Long live the LP!!