It's not the exact same as VBA macro extensibility, but you can do some pretty interesting stuff with it - build task panes, build embedded charts that leverage web content, etc.
And for automation I would rather use .net + ExcelDNA than javascript.
I can understand why they went the javascript route but that's clearly hearing developers, not users.
