You are looking for purpose in the wrong places, your ability to live and thrive depend on two things: realizing you cannot do it alone and having a reason to do so.
I am a man of faith, that faith which I fail daily has never failed me. I look for opportunities, not to preach, I am no pastor. But to seek out people that I can help, even in very small ways.
A waitress that has had a bad morning can flip it all when the right customer visits, a smile, a tip with a small note added. Hand a bottle of water to a UPS driver on a hot day, yes most carry their own but small things matter as does another human showing kindness, concern and just seeing them. Small of kindness are everywhere, helping someone load feed bags at a feed store.
Here is an example that I look forward to. Most months I drive to town and eat at the same waffle house, I have done it for years. Every December, I go in about a week before Christmas ask for the manager and give every employee 20 bucks. I save a long time for this; they have 12-15 at least at that store. It's not about the money, it's about people seeing their value. They are my favorite restaurant not because they know my name, because they act like they do. Last year, the longtime employees, smiled when I walked in and told a new employee that is him, smiles everywhere, I had made their day, the amount is small, 20 dollars extra is not life changing but it is what I can do, and they are worth the effort. My friends and family have no idea I do this.
I wasted years doing what you are doing now, looking for admiration, respect, purpose and even love from others.
When I realized that I had all those things, I did a 180, I explained to God that I was living for me, not him and to put people in my path that I could help, that changed everything. I will spare you all my good deeds, those don't matter, what matters is you need to understand that even a random stranger, from a website cares, really cares, and more importantly wants you to see your value, to help you find your purpose and thrive.
Here is what worked for me, feel free to use the parts that work for you. I started attending church, I started volunteering to help them, that opened more opportunities and added a bigger circle of people into my life. I can't burn money, I don't have a lot of that, but I can raise and grow food, I give a lot of food away. I fix and repair things for people that no longer can, visit elderly or call on people with no one.