Yeah, I've coded for Word since Word 6.0 in the mid-90's, and it has always been my feeling that Microsoft doesn't want to make things programmable so much as they want you to think things are programmable. It's a feeling that's hard to verbalize exactly.
I don't disagree with you at all, but that's what makes it even more strange that VB has become so much more popular than I expected for enterprise usage. Did Microsoft's marketing muscle pave the way, or were other tools really just too complex for what these people (business analysts, business logic developers, etc) needed?
This takes me back to my last (long term) job. I got tapped to fix a departed worker's spaghetti code, and in the process, got VERY familiar with Excel VBA, to the point that I started goofing around with my own ideas. I must have dozens of "empty" spreadsheets with nothing but code in them. What's fun is, you can drag in just about any COM library on the system to play around with.
It's 1994, Windows for Workgroups is on your computer connected to the other machines on the LAN via a Novell Network. No WAN. Word 6, Access 1.0, Excel 1.0. VBA is all you've got.