Can Streamed Music Sound Better than any other source?

I am about to make the leap. Jumping into a Server or is it a Streamer? To use existing DAC-Oppo 203- or upgrade? I love the concept of access to all the music on line. So I don't actually own any of it-thats fine. Buying downloads adds up quickly. $20/month sounds like a bargain.  Roon's system looks appealing. I can add Tidal and be done, right? I get a lot of great counsel from my old school expert at the HiFi store I support locally but he can't even spell stream.
I was born in the 50's and want to use this listening option now. As this technology is still evolving, I am not inclined to overspend on gear that may be as valuable as a VCR in a year or two.
In the end I want to know if I can have this new source sounding better than CDs and LPs. I am not going back to reel-to-reel so if that is best source, please ignore it as it regards my purposes.
Thank you. I look forward to learning from the responses!!