Designer is definitely more useful for tiling materials and fabrics. With painter, you have to rely on the defaults or finding substances on their community website.
Painter is mostly useful if you are not tiling much at all and instead using largely unique textures.