I do agree, unfortunately though, there could be a lot of great projects in the past that didn't have the support of the community for one reasons alone. Is that this projects might not make them money.
That's the sad truth of crypto projects, even in the last cycle, there seems to be a lot of projects that didn't have the consensus and everyone is going after the meme coins and those pump and dumps altcoins.
When it comes to meme coin projects, they are completely devoid of use cases. The reason is that use cases and technology require capital, development, salaries, and more. That is why we find memecoins dominate the market: Project teams are now looking for the cheapest and easiest way to generate huge profits from the pockets of greedy investors.
What the OP mentioned is a drop in the ocean of projects that offer more useful and popular use cases, and certainly, despite their low visibility, they are less risky than meme and pump-and-dump projects.