Hive's niche is decentralized text storage. It's cheap enough for that because its consensus mechanism isn't too expensive to run. Many kinds of functionalities can be built on top of a decentralized text storage. However, Hive does not run user-defined code. But that's ok because plenty of other chains can.