Disclaimer: I am affiliated with the project I am describing below.
You have a stab at one of the most important issues within the space here. You are right, most projects either do not have any utility or they are so far up their idea and tech that they think it will produce value by itself. Unfortunately, most things end here. For most, this value will never surpass the simple value of "exchanging value" or "storing value" (both are important I agree, but we are talking about tech, not money).
However, that is not how it should be. Projects should be building and solving issues, adding utility and providing solutions, otherwise, we are stuck in a system which produces the point zero problem. This can get us cemented in the past with no hope of any future.
Check out cyber. It is a decentralized google with a mission to open the semantics field and decentralize the service of the internet with the use of blockchain and economic incentives.
It's not an idea. Both, the chain and the initial app are working as planned. Yes, the project is still in testnets, but, it is 100% open-source and the idea is provably implemented.
Cyber managed to prove that it can change the current search mechanism and make it work. The main use of the network is to build an open, decentralized knowledge graph, by the users themselves to create a shared database of knowledge. All transactions in the network are made to target that purpose in one way or another.
Cyber utilizes the use of computation, bandwidth and storage and produces a useful computer with several use-cases, with the most obvious is the creation of an open and provable search in a trustless and censorship-free environment without the illnesses of web2 tech..