This site states itself as being

“The Worlds largest free texture site”

They certainly do have alot of textures.

http://www.cgtextures.com/

Grow ivy in your scenes to create some really cool effects. I have not had a chance to play with this yet but I can think of a few projects that would really benefit from this program.

http://graphics.uni-konstanz.de/~luft/ivy_generator/

Detailed video of modeling, texturing, and rendering a candel in Carrara.  This tutorial also includes how to setup SSS.

The tutorial details and video can be found on Polyloop.net you will find the video links about half way down the post.

http://forums.polyloop.net/carrara-tutorials/4558-modeling-candle-creating-realistic-wax-shader-carrara-5-a.html

This is a nice video tutorial showing how easy it is to model in Hexagon. Would be nice if there was sound but the author does an excellent job. The video quality is also excellent.

There is also a second video showing how to UV map the spray can in Hexagon.

http://forums.polyloop.net/hexagon-tutorials/16382-basic-spray-can-video-tutorial.html

This video tutorial shows all the step to creating a box of matches using Silo 3D. This tutorial can easily be used with other programs like Hexagon.

http://forums.polyloop.net/misc-tutorials/16385-matchbox-silo2.html

This is one of the first images I have rendered with Indigo.  The render quality is awesome, I think this render ran over night.

http://niel.seyanim.com/niel2/modules/newbb/viewtopic.php?topic_id=1632&viewmode=flat&order=ASC&type=&mode=0&start=0

In this set of tutorials the author focuses on modelling the Serenity from the TV Series Firefly using Silo 1.4 in the first Issue and Silo 2 in the remaining issues.

http://www.virtua3d.co.uk/

A list of 9 awesome video tutorials for Silo 3D

http://www.andykinsella.co.uk/tutorials.html

Learn Hexagon the EZ way with these 10 awesome videos.

http://www.ezbrush.mediabakers.com/fullscreen/EZ-HexVids.html