The videos are largely feature demonstrations, not tutorials.
Check out the written walkthrough tutorials here:
http://unikronsoftware.com/2dtoolkit/doc/If you are new to all this, I suggest going through all them and the Unity tutorials. It is quite essential that you learn how you do basic things in Unity as well.
As Copyright says the website & asset store page go into detail on what the product does. Note - nowhere on there does it say it draws your sprites, replaces a paint package or make your games for you!
On the other hand, it does simplify all the tedious things you will have to end up doing when making a 2D game in Unity. It also manages your atlases for you which is essential if you want to make a performant 2D game. It also does animations, tilemaps and other things which one would use in a 2D game.
You are free to draw your sprites in any package you choose - Photoshop, Pixelmator, ASEsprite, Pixen (Mac) all work. I've heard very good things about GraphicsGale too. There are many many options here, some better than others for various tasks.