Dear God, you are so right.
Lotus 123 macros were my introduction to the fact that "tools that you don't have to be a programmer to use" actually means "tools that end up being *immensely* more complex than any computer program because we don't actually give you the constructs to program sanely".
To this day, I still find people who loudly claim they are non-programmers because programming is too tough who maintain 'macros' whose complexity put my 100,000 line programs to shame. If they'd been given real tools, they'd probably have created human level AI during their coffee breaks, except, of course, "real tools are for programmers" and that would be 'too difficult' for them to even contemplate using.
I'd feel more shame for what my spreadsheet did to the sanity of the poor soul who came after me, but there was simply no way to sanely code 123.