Bruh...
I wish I could give good advice but I have similar feelings.
All those tips that come up in this sort of threads, post consistently, bend down to the algorithm, draw fanart of whatever's popular, use hashtags... I tried them, and was getting very little traction from them. So honestly it just killed my drive to create for a while.
Chasing trends, conforming to the almighty algorithm, making yourself draw fanart for traction, posting in hashtags and promo threads - all that has nothing, nothing to do with actually making art and finding enjoyment in it.
I think social media nowadays is just too huge and widespread. You're competing with tens of millions of artists. Unless you're blessed with godly skills and the content that you enjoy creating is just whatever is the most popular at the moment, getting "out there" is pretty much... winning a lottery... Someone wins it everyday - but statistically it's very unlikely it will ever be you.
In the distant era of smaller, less centralized online communities, it was much easier for artists to find an audience, and you didn't have to have thousands of followers to even be seen at all.
On twitter, I have what, 57 followers? which I gathered over two years of painful grind. I can't see myself ever going over 100, maybe 200... Unless I win the social media lottery and go viral at some point. But even that doesn't guarantee a long-term success.
Even when my art was recently retweeted by an artist with thousands of followers, it got only a handful of likes and I gained no followers from it - which is easy to interpret as incredibly demotivating, because does that mean my work sucks this much? It's just this uninteresting? I should've been happy to be noticed by an artist I looked up to for years (and I was), but I mostly got this bitter disappointed feeling.
I know my art isn't amazing but it's not terrible either and there have to be more people out there who could like it. Just, how to even reach them? Most of my twitter followers are from here, or one discord server I'm in. And while I appreciate those a lot, I feel I've no way too grow outside of these small communities.
...I'm honestly at the verge of giving up on social media altogether. I enjoy sharing my work with the few followers I do have that I know appreciate seeing it. But faced with the choice between continuing to painstakingly fight for every follower, and making art for my enjoyment, the latter is an infinitely healthier option.
So like... bottom line is... Social media bad?