Generally speaking, the heavier the cloth, the more solid the kilt will feel. Plus, the heavier cloth seems to give a much better "swish" in the pleats when you walk.

However, you can get a perfectly fine kilts in the other weights as well.