Two years deep in the web3 hole and after using practically every single protocol, I can't think of any "need to have" use cases either.

Everything is either completely unnecessary or a "nice to have". Like, say, trading video game assets. Or digital art. All nice to haves, but nothing that would even remotely warrant the kind of valuations the segment commands.