The noise is coming from the pistons rocking in their bores and is caused by the angular change in geometry from the crankshaft/connecting rod transitions. In the old days they just made the piston skirts longer to minimize the piston rocking and the noise it creates. With the manufacturers trying very hard to squeeze every possible 1/10 MPG out of their vehicles, the friction produced by the longer skirts is one of the things that they had to reduce. The oil you use will only have a minimal affect on reducing this kind of mechanical noise. Some higher end manufacturers are becoming increasingly sensitive to customer complaints about this noise and are experimenting with lengthening the piston skirts and bonding a thick coating of molybdenum to them to reduce the friction, but this is an expensive fix and not economically viable to use in lower priced mass market vehicles.