I think the best answer is "yes" and "no".
Setup #1: I have a PS Audio DirectStream transport and DirectStream DAC, and with an SACD in the drawer, I2S cable connecting the two, the technical sound quality is as good as it gets (native DSD exported from the transport to the DAC). I also tend to listen to CDs using this pair, when I'm listening to a whole album.
Setup #2: But I also have Roon & Tidal on a powerful Windows10 Pro machine, with a large external hard drive, for streaming or listening to this track and that track, and not an entire album.
I'd say that Setup #1 has the potential for superior sound quality, as the I2S interface isolates the timing from the music, ultimately capable of better performance in the DAC. Also, even with the great selection offered by Tidal, lots of classical music is just not available for streaming, but is on CD & SACD.
I'd say that Setup #2 has the potential for superior sound quality, as Tidal can stream newer "remasters" which might sound better than the CD or SACD that one purchased previously. And HD Tracks has a selection of hi-res digital files, which can be downloaded and integrated into one's player software, part of your Roon library.
So, in short, I have both and am glad to have them.