Outside of blogging via Peakd/Hive.Blog etc., Hive is powering layer 2 solutions, which means that it is not the backend, but one component to be used within the apps' backend. Example would be Splinterlands, where the actual code is being run on their servers and Hive is "just" being used as a decentralized db and verification mechanism.

It seems that quite a lot of people have the idea that blockchains are going to replace cloud providers, but I'd argue that even Ethereum, EOS and other SC blockchains aren't able to fully replace cloud providers; this will take far more time and I'm not even sure if that's what we actually want. A hybrid approach is IMO a pretty solid step forward.