Totally agree! I know a guy whose main job is basically to be an Excel expert (nominally he works in logistics), and seeing some of his work convinced me that he's actually a programmer who uses excel as an IDE - akin to visual programming.
It just depends on the environment. Some areas get to experiment with different approaches more than others. On one extreme if I was writing yet another crud app, it's unlikely is need any such tools. On the other, when dealing with data processing/visualisation/ml, it's small experimental tools all over the place.