When applied properly, a texture used as a background can add depth and set the over all mood for a web design, games and 3D-art.
Here’s some sites where you can find free textures:
subtlepatterns.com (Thanks A.A.)
80 inspirational textures
A library of textures
http://www.squidfingers.com/patterns/ (*oldie but goodie for pattern backgrounds)