You can get your CDs to sound as good as your vinyl and streaming can sound even better. The DAC would be the first step. It is a question of your transport and DAC, matched to the rest of your system.
I always look at the long term first. Do you want to improve your whole system over time? In that case each new purchase should be one level up. So, let’s say you do your DAC… then next your transport… or better yet a streamer. No reason to waste money to play the CDs you have when you can have access to millions of albums at the same or better sound quality.
But first things first what is the rest of your system. There is a place under your userID to put photos and ID your equipment. This would be really helpful for us to help you.