It is an "apple/oranges" kind of thing.
I am finding no matter what the source/medium - a lot comes down to the original production, soundstage, sound engineer, original mastering. Some of my CD's, non SACD, sound exceptional on my system...they were produced well, on a great sound stage, and a great first master, on par with my analog vinyl. A few of my SACDs - not so good. The same holds true in my digital music catalog. To try new things, I picked up a few CDs & downloads from 2L productions (Borders & Pax), as they are known for pushing the recording quality to the best possible = and yes they sound great both on CD and downloads: https://shop.2l.no . PS Audio also has stated producing high quality albums...I have not heard any https://www.psaudio.com/collections/octave-records
Streaming is the same - in my system; I feel if the original tract was done well to start with it usually sounds good. I stream via Tidal, many of the 24 Bit/192 KHZ sound great, some not so. My digital library is the same...some good, others no. Even on U-tube music there are tracts that just sound exceptional in my system Steve Windwoods latest cut of "Cant find my way home" https://www.youtube.com/watch?v=eoSn2Y-b6wI, & also his https://www.youtube.com/watch?v=bXDcPoeIx-E&list=RDbXDcPoeIx-E&start_radio=1 or Christina Aguilera take of Moulin Rouge https://www.youtube.com/watch?v=RQa7SvVCdZk&list=RDRQa7SvVCdZk&start_radio=1
A few of my brand new "high quality" vinyl albums - just sound poor from the start. If you get the 170 pressing of an album, it is different than the 170,000 pressing. A few of my original albums from the 60s & 70s sound better than the newer remakes, actually – many do.

