Try scaling your object! When scaled up does the texture look realistic - tile it - do the tile join well?
Lest say:
I want to apply materials to a terrain model - picture won't work.
I have a large model and want some variation in the material - picture won't work.
Pictures have their place - so do decals, procedurral mats etc, etc, etc
BS