The VG Resource

http://smashinghub.com/25-really-useful-...orials.htm
Some more tutorials

*hit and run*

- Skintones - Part 1 of 6 (you can check the other parts at the artist's comments)
- Another realistic skin tutorial
- Painting HANDS
- Sky tutorial
- Realistic hair with pencils
- Faces (cartoon)
- Watercolor tutorial
- Folding - Part 1 of 2 (the second part is at the artist's comments)
- Kimono tutorial

- Skin texture brush for Photoshop
- 350+ vintage and retro Photoshop brushes
- Japanese patterns (to go with the kimono tutorial ;p)
- Screentones and other useful resources
- 40 hi-res textures
- Lots of free textures

All post here are really interesting and useful tutorials. The videos are pretty cool to understand.Really appreciate all for their work.

http://www.mydamnchannel.com/You_Suck_at..._1373.aspx

You Suck At Photoshop is pretty much the most memorable and depressing set of tutorial videos I have ever seen.

http://forums.somethingawful.com/showthr...id=3393021

This may phase in and out of readability if you don't have an SA account, but it's a pretty in-depth thread where two guys in the animation business talk about their technique and other things.

We have a lot of new links now, are you interested in reupdating the OP, Dex?

Art-Related Website
http://www.pixiv.net/ (japonese)
at the botton page
you can change to english

OOOH yea I view the R-18 section a lot.

http://pinterest.com/characterdesigh/ amazing resource for character design, anatomy and a bunch of references

also androidarts' great tutorial http://androidarts.com/art_tut.htm