Here's the video of a character I did for class, Sculptural Texturing. First we had to draw a concept, and then model it in 3D in maya, and finally add detail in ZBrush. Did the textures on Photoshop and ZBrush, and the video with AfterEffects.
I'm pretty happy with the concept, but the end character is a bit... lifeless. I don't know how to rig though, so no pose.
I don't know if I'll be using any of these programs again (except photoshop). I'm done with the classes involving maya and zbrush, and it sure is a nice knowledge to have in the future. I enjoy plain old school drawing more though.