Scripts are usually used to either enhance or modify the normal behaviour of mIRC. It just depends on what you want to achieve.

The best scripting resource is mIRC's help file. Type /help on your Status Window to open it up. You can then browse through that to get some idea of what is involved.