The only interesting aspect of blockchain is decentralized trust - trust being the key part. If you don't need decentralized trust you don't need blockchain. And outside of a global currency, there isn't much that needs that.
DeFi is just unregulated speculation / ponzi schemes. People came up with new systems (supposedly faster than bitcoin) to send currency back and forth. People are flocking to it hoping to get rich quick, but it doesn't actually deliver anything novel outside of not being regulated.
Internet Computer would be cool if it was actually decentralized. But it's not:
> The Internet Computer hosts its own governance system, called the "Network Nervous System" (NNS). In order for a data center to provide compute capacity to the Internet Computer network, it must acquire a DcID (Data Center ID) by making an application to the governance system
And unfortunately making a decentralized version of what Internet Computer wants to do is _very_ hard (maybe impossible).
So many of the newer "blockchain" tech is considered useless is because, like Internet Computer, they cheat and introduce centralization because of the technical limitations of being decentralized. BNB/BSC is a huge example of this (one of the major new "defi" networks).