In your experience, what social media site have you had the most luck getting attention for your games or assets?
My own website.
Seriously, there's no magical solution for getting noticed. You have to be in a bunch of places, and be active. It's called social media for a reason. No matter where you go, people won't know you exist unless you interact with them first. That's equally true on a (micro)blogging platform or a good old forum.
Have something to show. Have something to say. But mainly, be there.
Twitter is still good, mostly because my target audience congregates there. But if I were to start again I definitely wouldn't choose it.
Tiktok is 100% the way to go, no other social media comes close. Figure out how to translate your content to video - gameplay, workload, tips, day in the life of a dev, etc - and just stick with it.