I don't think that noise and wear are related. I do think that engines and drive trains resonate and emit harmonic "noise", or what we call minute vibration.
Some oil do a better job at minimizing or damping that vibration at different engine speeds or RPMs. It can dampen it at lower RPMs where most people run their engine in than at higher RPMs, where the automatic transmission will least likely stray for reasons of fuel economy. Then, there are other oils that dampen noise at higher RPMs than lower ones. I don't think tribilogists do this on purpose when they formulate oil, but it's just the characteristic of the oil.
I'm just theorizing this based on the changed harmonics of my car when I changed out my passenger side CV axle from the OEM hollow tube to an after-marker solid shaft. My car started to vibrate at 3800 to 4500 RPM. After much research online, others who had the same problem pointed out the new CV axle. After they switched back to the OEM ones, the vibration went away.
This makes me think that engines and drive trains do create harmonic noise and anything you put into it like engine oil will affect it. Just a theory.