I agree with scripts being most useful for modders. It really depends on the scope of your project. For me as an artist, scripting is handy, but its most useful when its embedded in your level design and modeling tools, but still accessible externaly in an IDE so that coders get to play too.
Unless your scripts can be compiled in some way, they can be slow, and not really ideal for defining gameplay, advanced AI and what have you.
Unless your scripts can be compiled in some way, they can be slow, and not really ideal for defining gameplay, advanced AI and what have you.