There are so many examples. Some of the most popular web3 applications have only gained more momentum over the last few years, and have growing user bases. Examples are: Uniswap, Compound Finance, Maker DAO, Aave, Curve Finance, Tornado Cash (which is incredibly useful for preserving privacy), and more. They actually provide a service people care about and use. I agree they are still at a small scale compared to traditional web applications, but I personally know people in developing countries that rely on stablecoins to survive, such as DAI, use Aave to take out loans, and Tornado to preserve their privacy from tyrannical governments.