Tile Finder background image in Snow Leopard
It can't be done right now.  Even if you made a background image in Photoshop the size of your display and used that, you'll find that with certain views (eg narrowed windows), you'll still see the edge of the image.

Someone somewhere just might write an app to do this, and in my opinion it would be popular.

Until then, we're stuck with just colors.