I had fun last weekend playing with textures. I chose a photo I like of an old sink. First, I borrowed a free copy of a texture called Softened Faux by "Skeletal Mess" from Flickr, placed it over the sink photo with a little blending, then HDR'd the single photo. I thought it was kinda neat.
Then to use the photo for a Camera Club competition on textures, I chose to do something similar with only my own photos. I took a photo of a crumpled sheet of paper and superimposed it over the sink.
Very interesting for a first attempt. The texture didn't win, but I will probably use the photo again.
Photo with crumpled paper texture