High viscosity oil, meaning thicker I believe is less likely to cavitate.
The issue being overlooked here is atmospheric pressure is a finite number, and that is the main thing with gravity helping oil find its way into the pickup. Running vacuum pumps with a wet sump reduces the help ambient oil pan atmospheric pressure provides feeding the oil pump. Regardless, all the oil required by the pump is restricted by the area of the pickup inlet tube (less than .5"D?) multiplied the length of that tube/restriction. I submit any other area of restriction that is under consideration here that is greater by than more than twice(?) the size of the pickup tube cross-sectional area and many factors shorter, is not worthy of consideration, beyond the design needed of preventing sucking air.