Being effective at automating procedures or workflows reuires a more or less deep understanding of all components and how the interconnect, as well as an understanding of automation
frameworks/tools. One can therefore reason that building a usefull automation can be seen as a way to learn system modeling, software design and all other needed software/hardware componets.
For an example see Projects->Python->Video Generator->Example Video
. The Character animation and skin are procedural so one can build a divese set of loops in no time.
Building this required knowlege of python,blender,blender materials/shader-nodes and more. By automating the process I learned some basics about all of these areas even if the end product is never used again.