Lightweight oil flows more easily and can get into all the nooks and crannies inside an engine easier than, say, 10W-40. Basically, modern cars use lighter, lower-viscosity oils because they can.