Apart from some people using your software until they move to something more famous, nothing ever happens after you release a script, all you you get is getting your scripts lost among the crowd.
If you create something that is useful, has something to set it apart (even if only small), have an easy-to-use interface so that someone who knows nothing about the script could use it with minimal reading, then you have a good start. There are scripts like that out there though that never take off. The thing that many good scripts/programmers are missing is a good marketing plan that provides a strong launch to market, along with a good system for continued support to maintain customer loyalty.
There is no definite answer to this question. If your script is really unique and useful, then it is worth all the time and money spent in developing.
If there is huge demand and there is no good script - yeah there is defiantly good thing to script it. You need some unique script no the next Facebook
Think of something that YOU would use everyday. Then make it, keep working on it every day, and eventually you will have some good software that has a good use. Gauging demand for such a script is crucial. If nobody wants it, don't even start it if the goal is to make money. You can spin your wheels working on seemingly pointless projects for a long time if you don't check demand before you start coding.