"Heavier" string gauges - i.e. those that have thicker strings, give more sustain, and enhance a guitar's natural tone. They often hold their tuning better than lighter gauges.
"Lighter" string gauges are easier to "bend" notes with, but have a much thinner sound. However it is also easy to accidentally bend a note out of tune with light string gauges.