I want to know if you can basically make sprites and animate them in Unity instead of using another software.
Make your assets outside with tools designed for the job, import them in. Yes you could through many lines of code make and animate but not in the way I expect you are asking about.