Heavier lenses are harder to move, hence less camera shake. But if you get too heavy, you will shake due to the weight, so there is a happy medium between too heavy and too light.

That, of course, is in addition to the obvious ISO/Aperture/Shutter speed issues, and the fact that the above does not apply to P&S cams.