I'm not really sure what you're looking for so you get a little bit of everything. http://itchstudios.com/psg/art_tut.htm http://conceptart.org/forums/showthread.php?t=107217 http://www.petesqbsite.com/sections/tutorials/tuts/tsugumo/ http://www.pioroberson.com/extras.php…
ahhh the good ol apple painting tutorial - great place to start. can't forget: http://www.game-artist.net/forums/spotlight-articles/42-tutorial-hard-surface-texture-painting.html