I was in a similar situation when my Audio Aero CD-player broke down. With (too) many CDs I was recommended to go for a used Accuphase DP-67, around 2008 considered as one of the best CD-players around. Indeed, it sounded really great. But when I connected it to my Merason Frerot DAC it sounded so much better. Obviously, modern mid-priced DACs are much better than the ones in state-of-the-art CD-players of about 15 years ago. So if you want to buy an older CD-player, focus on the quality of the transport and add a modern DAC.
My next observation was that all the CDs I had collected between 1990 and 2010 sounded mediocre compared to streaming them in high resolution on Quboz. So I sold the Accuphase, and had the Audio Aero repaired for the occasional time I want to listen to a CD that is not in Quboz.