"thicker" gauge will yield a more bassier sound and "thinner" will provide a brighter sound.
Some guitarists, due to heavy picking, tend to break the finer strings and therefore prefer thicker gauged strings.
Some play on very down-tuned guitars and a heavier gauge will mitigate string slack.