I wouldn't go as far as YouTube, but this is pretty much my alley so bad it's not even funny. One thing I learned fast is that due to social media, the world is large and very small at the exact same time. I know that on some sites, when it comes to like artwork, etc. There are bigger channels, accounts, etc that try to give a spotlight to smaller creators. Not even 10 minutes ago I saw a post an associate of mine commented on twitter about some art he made that was one of those aforementioned smaller content creator spotlights.
Do you consider this to be something that anyone can accomplish through their own efforts?
Yes, but working with others can't hurt. You should have a plan with the content you create so that you don't just create it and be like...what now? Sure, create it still, but have an idea of who'd want to see it, consume it, etc. Plus, there is the realization that everything eventually fades to a degree as time moves on. Games for example are a big example of this. A popular game now might not even be around in 5 years, or even another game might overtake. Looking at you PubG. They were out-taken by Fortnite.
Is it something that you need a particular mindset for or is a particular skillset more important?
You need to actually enjoy interacting with people. If you're a misanthrope or a Mal-adjusted introvert you're going to have a bad time. Having writing skills at the least could go good distance, as you gotta keep in mind you're delivering a message. Writing is just one way of delivering the message, but overall writing and other creative skills go a long way. I also agree with [MENTION=4050]ceecee[/MENTION] about embracing how people communicate with you. Your company's twitter might not have as many follows as the Facebook page, so you have to adjust to where you get feedback and where you deliver information.
There are analytical tools out there for these sort of things. I recall seeing data a person I knew at one point gathered about days where they got the most responses on certain social media posts and interactions with content consumers.
Though yeah, if you're pessimistic about people, dislike interacting, dislike answering questions, or worse, you hate the creative process and would rather things be A -> Z, then you are going to hate it. I've seen some seriously horrendous attempts in the past, of people trying to get things out there. When it comes to social media influence, language barriers can be seriously troublesome for people.