I just obtained some SACDs from Tower Records in Japan. Early 1970s recordings featuring conductor Kurt Sanderling and the Berlin Symphony in symphonies of Sibelius and Shostakovich. Remixed in analog, then converted to DSD. I have been streaming the same recordings from what is presumably the high res Redbook layer on the same SACDs. Both are excellent but the DSD is more detailed. There is more sweetness to the strings, brass has more oomph, the double basses grounding the sound floor with more solidity.
I have hundreds of SACDs. There really is no comparison. Redbook has improved and vinyl will always have its adherents.
Sony made DACD difficult as others have noted. It also became dragged down in a format war and was tied to multichannel. Most consumers couldn’t be bothered. Most thought mp3 through 5 dollar Apple buds was all they needed. Convenience beats quality in our society