I'd say anything that is reusing a lot designer is king to build the trim sheets or tilables. Any unique asset will profit from sculpting. That being said, nobody is stopping you from using designer generators, textures etc to texture your uniquely sculpted mesh
Designer is not a quick way to do things actually and final substance may be so complex you could hardly able to tweak anything in the beginning of the node flow. It's often like a house of cards. You touch something and it no more looks real. Especially with the scale of things since you may need to size in sync every…