The better vinyl setups will push the music forward and the noise to the background.
I think that....
Music Lovers push the music forward and the noise to the background.
Audiophiles will hear every little tick and pop. This is also one of the reasons that those that never had history with vinyl - prior to CD - struggle with vinyl.
Vinyl has a noise floor.
How quiet it is will depend on who did the cut on the master disk.
It varies from record to record.