It's mostly _ME_ who uses the advanced features, not people around me. In cca last 10 years, I've seen exactly one Excel with macros that someone wanted other people to use. (No, you can't use VBA with LibreOffice, just like you cannot use Python UNO scripts with MS Office).

The reason is mostly security: nobody wants to run random macros on their machines (where nobody means their IT departments, the users wouldn't care) and for the uses that you mention, for random forms, web-based forms are used and links to them are getting send.

At least in my corner of woods.