And that hybrid is why blockchains claiming "decentralised" and "immutable" are actually celebrating falsehoods. It's more about the marketable buzz words to attract users. Which, evidently don't achieve the intended goal anyway.
I'm in agreement with you that hybrid is the only possible solution. I've always seen it at such and view Blockchain as maintaining "the DNA" or "nuclei" of systems. So I cringe when people say "censorship resistant" but they have no clue that all the data actually lives on servers controlled by centralised entities.
Only reason why it's not censored is because it's not actually disrupting in a way that say "conservatives on Twitter" are creating disruption against the status quo. However if there was to be a wave of influence out of these niches then the service providers would most definitely bend to higher powers.
IMO, the true Revolution of solution to truly immutable would be for each user to be the service provider. Where each user has fragments on the data stored on their home systems and by that contribution maintains a virtual entity of the system. Similar to how atoms exist by maintaining a digital signature of their energy expression and contribute to the virtual cloud which is then what is expressed as "physical" mass. Technology isn't there yet for that though. One would need a very large machine to provide adequate contribution to that mainnet. In the future a system of what is now a supercomputer will be in a usb drive and we could be nomads physically, but connect to our digital systems simply with an access point.
So my view is that these current Blockchains aren't that great. They're part of the development but the mere fact that they haven't replaced the old (for reasons you've pointed out) are why investment into these systems is not really moving. Money goes where gains are plenty. Obviously DeFi is that example. Speculation (gambling) though is predominantly that draw.
SMT promised much but delivered none.
Because... well, ideas are great in theory but we don't yet live in a virtual world. They need to be made tangible for their greatness to take effect. That's the other flaw here with Hive (and BC technology in general). Ideas for days. Little action for years.
RE: Hive Is The Back End For All Applications Built Upon It