"My question is if this is your conclusion is that it's a solution in search of a problem, what was all that effort being spent on (not just in finance, but everywhere blockchain is being considered)?"
That strikes me as a very rich question that would be interesting to investigate. Yes, we know people can get involved in hype cycles, but what was it about this technology that made it the thing that got hyped exactly?
Perhaps a subconscious association with BitCoin and getting rich quick hit the people most prone to hype? Some of the blockchain projects being proposed, I honestly couldn't see how they were planning on profiting from it. I don't just mean profiting enough, but profiting at all; what was the mechanism by which money is transferred from some set of customers to the blockchain creators? Preferably with the transfer of some valuable good or service in the other direction, but, you know, technically that's optional from a business perspective.
I understand the answer for new cryptocurrencies; the creators start with more of it than the incoming users and that becomes valuable as the currency becomes valuable. The non-currencies I didn't always see an answer. Which is why my best guess is some sort of subconscious belief that anything that has a blockchain will automatically somehow become wildly valuable via (underpants gnomes step 2 here). It's kinda a copout answer but it's the best I've got. Improvements? (Again, beyond just "people do hype." Why this hype and not something else?)