I'm not an SM Manager, just a solo founder with very little SM experience or time trying to automate as much of my SM content as I can, so take my words with a grain of salt. How much of this are you already automating?
I'd say at this point it is possible to automate essentially anything which is just clicking and typing. e.g. Scheduling/Posting, brainstorming content ideas, uploading pictures and videos, putting together basic brand-aligned graphics, writing appropriate replies, data analysis etc. You can also AI generate basic product shoots, e.g. a picture of an energy drink with beads of water on it, NOT whole Reels (which is possible, but more expensive and time consuming than you may like).
You CAN'T automate: Taste (sure an image it may match your guidelines but is it good? thats still your job to decide), shooting & editing IRL content, overall strategy and direction (I mean, you can automate this, but it will always need adjusting and its a bit silly to be managing a strategy that you haven't set or engaged with yourself), probably loads more that I'm not aware of (as I mentioned I am very new to Social Media management)
A big limiting factor is how much control platforms are willing to give away via their APIs - some won't allow you to post comments or properly schedule posts without paying them a bunch of money which may or may not be worth it to you (last time I checked, the twitter API cost around $200 per month!). It also obviously requires a lot of time still looking at AI generated content and will involve teething problems at the start as you get your workflows to align with your actual ways of working, brand guidelines and your own taste.
If you haven't already, a Claude Max subscription is imo completely worth it. You can connect it up to no-code platforms like n8n via MCP connectors, install skills for building these and have it write basically any kind of workflow you wish (quality not guaranteed). You can even create brand guidelines and instruct Claude to create graphics and posts based on that.
tl;dr - yes, you can automate stuff a bunch of point and click stuff, but set up takes a while and some things simply cannot be automated
Happy to discuss it more between prompts, though I am off shooting pictures today for my barely existent channel so may not be immediately responsive.