Some of the vintage players had extremely stable, low-jitter transports, better than almost anything made today, and a few of them actually sounded pretty good. Some of the early recordings sounded bad, though.

But DACs overall have improved a great deal, with better resolution and more analog-like sound quality. If you can combine the two effectively --a well-made transport with a great new DAC-- it might give great "best of both worlds" sound. Be aware, though, that the connections between the units often introduces jitter, which should be minimized and which possibly has to then be electronically removed, to prevent it from more than offsetting the gains from the better DAC.
That said, SACDs are inherently better, with a higher level of data that translates into greater sound quality. Even a mid-quality SACD player with an SACD disk should out-perform even a good redbook CD player. SACD is the format that finally approached in quality what all the false hype and hopes for CDs was like when they were first introduced... sadly, it died in the mass market almost as soon as it came out (stillborn, really, due to some bad corporate decisions), although happily, there is still a substantial niche market for it, and lots of great titles available if you seek them out.
All that said, however...
ALL CD players, are being made pretty much obsolete by advances in hard-disk based replay. Use something like EAC (Exact Audio Copy) to copy your CDs to a hard disk. Ideally, use a solid-state (no laser, no spinning) hard disk, to eliminate that source of jitter. Take the signal directly out via USB, to avoid the relatively noisy computer environment and poorer-quality built-in DACs (even in "good" sound cards). Use something like a Trends Audio UD-10.1 to feed a good external DAC, or use a good DAC with built-in USB input. Add anti-jitter and upscaling, if your CD isn't already high-res. The sound output will amaze you; it equals or bests the most expensive CD players.
You can pay a lot of money to get this technology in a stand-alone music server, or you can do it today with any computer and a few peripherals, for less cost. Virtually all of the high-end audio showrooms here selling megabucks exotic gear have switched to this kind of source over the past two years, although many still have TTs and allow A/B comparing of vinyl and digital... there really isn't much difference; the differences between the actual recordings are greater than the differences between the TYPE of recording (media).
I'd say the best overall set-up would be a state-of-the-art hard-disk-based server for CDs and a high-end SACD player, to provide a digital balance to the all-analog tape and vinyl sources.