Graeme, as with many aspects of life, it is management of expectations that is key here.
Whatever the merits (or not) of compact disc sound quality, it is fair to say that before CD mass-market formats (vinyl/cassette/8-track/AM radio etc) were inherently noisy. I am not including R2R @38cm/sec, and FM tuners fed by a Galaxie aerial here because these were hardly mass-market items.
We were, therefore, effectively conditioned to expect, and to live with, sonic imperfections unless they rendered the particular medium unplayable or unlistenable.
If noise was present on a CD, it was likely because the artist/producer wanted it there. Latterly, we have had the rise of streaming in its various iterations ; again, an essentially “silent” medium.
Last year I invested fairly heavily in my Sondek and bought an external phono stage to replace the boards in my 52 and, latterly, a very nice Clearaudio RCM. Since then, I have bought the new Zappa box-set “because Zappa”, but have mostly bought CDs and streamed Spotify.
I do however, have in the region of 2000 discs bought, acquired or inherited over the years, and have little desire to add to that number.
Call me a tightwad, but I look askance at the prices being asked for vinyl today, whether new or secondhand. (I say this being fully aware that LPs are still relatively cheaper than when I was buying them as a not particularly spotty teenager).
Having said all the above, if you are finding a disproportionate amount of vinyl purchases warped, holes not centred properly, then that is a different matter entirely. The expectation should be that you should always least be able to play the records!