I've heard that for most people, the costs far exceed the revenue (until they reach the top 20).

That's my understanding, too. For this scenario, the witness would definitely be secondary to having a local API.

Hivemind setup info is here - https://developers.steem.io/tutorials-recipes/using-hivemind. I've never done anything with it, though, because I assume the storage cost would be fairly high.