Honestly Ethereum tech does get me quite interested. The idea of being able to create custom ledgers with tokens on the chain for bookkeeping that's maintained by an independent third party seems useful, as does the idea of smart contracts (dynamically & automatically executed transactions based on pre-defined conditions).

That would put the value of Ether at the value of being able to make transactions though - and at the moment transactions are clearly way too expensive for it to be particularly useful. The only value from these high transaction prices is extreme replication (many miners confirming the transaction) but I don't think anyone cares much about that level of security.

A heavily digitized financial system can also allow micro-transactions that can enable new things, e.g. to give a random example it would become much easier to pay $0.005 for every action you take on a website which could create entirely new business opportunities.

Edit to add - One way that I can imagine this developing is that "regular" currencies start moving their currencies onto a blockchain like Ethereum. I think that would make a lot of sense from a technology perspective and it would avoid the oddities I mentioned above (about wealth being mostly related to time of currency adoption). At that point the price of Ether would really just have to go to the value of making transactions and that doesn't make it look like a buy currently (at all).

I know this is a Bitcoin article as it involves people very new and ancillary to the space but most people in this ecosystem work on Ethereum as it's where most things are happening so I'll use this as my starting point. A good and respectable source is https://consensys.net/blockchain-use-cases/

Blockchains have lots of use cases that various groups find important. Most people only know about money (e.g. Bitcoin) and that's not super useful for first worlders like us but is actually a necessity for a large portion of the world from third world and oppressive countries like Venezuela, Iran, etc. Having the ability to trust mathematics rather than fallible human institutions is indeed useful for a large portion of the population.

The rest is basically realizing we are in about the 1997 era of blockchains where things are hard, the big use cases are still being built out and designed and it's generally just a playground for bleeding edge nerds. But it's growing fast and DeFi (decentralized finance) didn't even exist until summer of last year.

Some things possible today:

-Financial stuff: decentralized lending, borrowing, programmable assets, no loss lotteries, gambling, etc.

-Art stuff: NFTs (non-fungible tokens) allowing for artists to sell their artwork online (look up Beeple), games making their items digital and tradable and usable in other games (God's Unchained, Axie Infinity), sharing of real world assets (RealT, any kind of physical asset on chain such as a car or house)

-Organizations. These are called DAOs (decentralized autonomous organizations) which allow for an organization to exist and make decisions with fully secure digital voting which allows for employee owned corporations, gaming/interest groups, or even small cities or countries to run their bureaucracies in a provably neutral, safe, and transparent manner.

-Enterprise stuff. The Baseline Protocol by EY is fairly hyped among corporate types (which don't get excited easily) and allows for business workflows/ERP to scale beyond a single enterprise. Microsoft, Coca Cola, etc are building some neat stuff on top of this.

Most of this stuff is complex enough to have at least a few paragraphs each so there's no way I can do it justice or make it sound less crazy from the outside but there's a ton of innovation going on with many different possibly world changing protocols and services being developed so while it might not seem like much now it will likely be something people use without even thinking in a few decades, just like the internet itself.