Lots of great tutorials by Kirisute, covering everything from minor post-work to hand painting highlights and hair HERE.

Also his most excellent weapon and accesory texturing tutorial available HERE.

(NOTE: Free Startiste membership is required for the second link.)

<-insert words of wisdom here->