Yes, you can listen to vinyl that is nearly noise-free.
Playback system influences and record condition aside, some vinyl does play black quiet. I clean and play 2-30 records a week before listing, mostly classical and jazz and I have noticed some patterns with regard to certain labels and unwanted noise. A lot of DGG/DG pressings from the 60-s-70’s play black quiet. Most Japanese pressings I have listened to are also CD quiet. Some UK pressings. It’s mostly the quality of the vinyl. I can spot a record that will play quiet- it has a certain type of shine- like a sheet of silky black glass.
There are a lot of factors that go into making a quiet vinyl surface. Vinyl pellet quality, processing variables, cleanliness of the vinyl (dirt and regrind) and the amount and type of plasticizer used to keep the vinyl soft. I believe, in general, that the Germans and the Japanese are better at formulating a quiet vinyl compound than most. Plasticizer has a half-life and some formulations age poorly. I have opened many sealed RCA Living Stereos and a large proportion play with surface noise- even after a good cleaning. I am convinced it is the way the vinyl compound ages with RCA pressings. DGG pressings of the same age and quality generally play CD quiet.
I also believe that cleaning is a worthwhile pursuit. I have tried many methods, chemistries, and machines over the years and removing unwanted noise and cleaning up the original signal is possible through a good cleaning. I don’t believe that a very expensive RCM is necessary. Most I have tried are not addressing the real issue- they only provide more convenience.
I am getting impressive results cleaning with just a mild surfactant/detergent and very pure water. No vacuums and no ultrasonics. I do it by hand with a material I found that provides the right amount of agitation without harming the vinyl surface. Enough said.
I can’t make damaged, deformed or worn groove walls magically come back to their original shape, but if there is something hiding in the groove, I can get it out. And it’s worth it to me. I am sometimes shocked that 50-60-year-old records that look hopeless and would only get a Fair to Good visual grade can be cleaned to play quietly. I’ve had friends ask me if I used an ultrasonic cleaning machine.
So, if unwanted noise bothers you, I would say, yes- quiet is possible.