For Hypercard, I think the answer is that, at the end of the day, people will write off any technology that gets "stuck". Spreadsheets are amazing (I have a secret deep love for them) but you can't code with them without hitting a wall of what they can do. SQL and declarative languages are better but still suffer from that granularity issue.
[Disclaimer: I work on a hypercard-like declarative language.]
[Disclaimer: I work on a hypercard-like declarative language.]