Compositing these scripts just multiplies the reliability which, being less than 1.00, increases the unreliability dramatically. While on the subject, I should confess to VisiCalc's keystroke macros. Alas, the expedient decision was copied into other spreadsheet languages. Again, the value of automation is high enough that people just put up with it. Just like MIT secretaries thinking Teco programming was normal.
Scripts are attractive because they are relatively simple to create and maintain.
They also typically allow you to use entire applications as building blocks. This provides real power and leverage. But the price you pay is in reliability. But that's a small price to pay compared to not being able to automate the task at all. Or, at least, not without lots of additional effort.