That's adding a lot of constraint to the simple list you had in your first comment. It can do all that, just not perfectly like you start asking for in the reply.
What I find crazy is that if you're an animator, why are you paralysed when it comes to fixing mistakes? There's a spot between it can't do anything and it does everything for you, and that's where it is right now.
It's a bit how people say it can't code. "It makes mistakes and then I have to fix them". That's part of the task! It aounds like when someone types in something into to the prompt box, they feel like they lose all ability to modify it after.
And ya, it can't code a huge app all on its own in one go, but just like how it can animate a scene here and add some special effects there, it can code a function here and a helper script there, etc.
I feel like you are wrapping it up in your own expectations and ignoring the things it can do because of that.
I don't mess with the animation part all that much, but I have been using Sora and I'm also part of a discord that talks about it a lot, I see what people are doing with the open source tools and it's a lot farther along then it's made out to be in this sub.