Teaching myself Umbraco and uSkinned, I decided to just build an inspiration collection for all of us to have as examples of work.
TextureLabs
Textures
A great resource for high quality texture resources. He also has a strong youtube tutorials
Blkmarket
Texture Resource
A wide variety of grunge and other overlays that can be useful depending on the project or for additional effects.