The one thing that still makes me excited for this tech is web wallets and being able to pay/send money with them. If they are widely adopted, and a safe stablecoin (maybe even a CBDC) becomes the defacto transacting currency with quick on/off ramps, it would really change the way we pay for things online.
Like buying a monthly subscription for a tool like, say, Icy.tools, is so much faster when you can pay directly with metamask. No accounts, no logins, no credit card screens.
The catch, of course, is that for the tech to get adopted by the mainstream, you will need way more regulations and safeguards. Maybe KYC on wallets (which means creating accounts/logins), maybe the ability to reverse transactions to reduce fraud.
All of these regulations might introduce enough friction that the final experience doesn't differ much from current legacy systems.
But a built-in browser wallet that makes payments (including micropayments) easier is really needed. It's the only antidote to our current advertising dependent model of the web.