I find behance to be a very motivational site when thinking about projects to start up. Theere is a good contrast in work. It also a good place to showcase your work. You select from all areas of the creative industry which means people looking for artists can visit the site an find your work and if you what they are looking for, possibly hire you for a job. You can also view artist portfolios adn some of wqhich contain tutorials from the artists to explain techniques they have used in there work.
Kim Vongbunyong caught me eye on this site, a 3d artist that does modeling, texturing, lighting and composting. His main job title as a freelancer is texture and lighting artist so he seems to specialize in theses main areas as well as being able to model and animate.
Looking closer at one of his animations see below a fish he created for one of this animations, I really like the attention to detal in both the modeling and textures Incorporating metals into the design and texture.