The problem is not so much that these thousands of cryptos don't do anything, it's that they all do the same thing. So many of them are just copied and pasted with little or no difference, and that limits use cases for each one.

The market is diluted and that means many chains will just fade into obscurity.