Nobody has ever claimed that you can run normal computer programs on the Ethereum blockchain. It isn't meant to run fucking Doom. Smart-contracts are more like financial protocols.
Blockchains are a form of database but they are not meant to store large amounts of data. That's more a job for IPFS.
Ethereum is migrating to a layered architecture and users are meant to stay on Layer 2's which provide substantially cheaper transactions.
I'm a fan of cryptocurrencies because I think there should be a spectrum of centralization <-> decentralization. If someone wants to stay centralized then fine but I should be able to handle my own money without a bank. I also believe that cryptocurrencies reduce financial friction and overhead. Taking donations is as simple as posting your public address. Taking payments means just integrating a library in your application instead of signing up with a service.
I'm a fan of NFTs because I think people should have ownership of digital items. I think if I pay money for Hearthstone cards then I should be able to sell them on my own terms just like Pokemon cards in real life.