Feel free to add to the list.
After a lot of research, I figured I would make a list of projects that actually solves some of the key problems we see in our daily lives. There are thousands of crypto projects out there among all the meme coins, scam coins, and dead projects that deserve to get some spotlight.
BitcoinThe KING of crypto. First mover, store of value.
Ethereum Smart contracts and a huge network of projects build on top of it.
ChainlinkDecentralized Oracle Network.
Basic Attention Token Removes the middleman between advertisers and publishers
DIVI Project"Crypto Made Easy" - Eases the entry barrier to cryptocurrencies, making it as simple to use as possible. (I.E: Send money straight from your bank account to the DIVI wallet).
Monero Privacy, plain and simple.
These are just a few... Feel free to add your own!

I hear what you say and I understand why investors always ask that question "what is the real-life purpose of the project" but come to think about it, has there been any crypto project regardless of what it is listed for as you mentioned above that investors are not concerned about if they can make profit "MONEY" out of their investment? As far as I know, all investors main aim is Profit including Elon Musk
So to me, once I can invest in any project be it BTC, ETH, or any other as long as I can make a profit from my investment, REAL LIFE PROBLEM SOLVED cos that's my bottom line for investing.