If the results people want are a literally dragged and dropped material with little to no actual texturing work or thought put in then they’re not setting their sights high enough.
This isn’t a problem specifically with Substance, it’s a very cool program with a lot of potential, but the unfortunate result of its popularity is that now a lot of people who would otherwise be going and finding tutorials like the one I linked that explain the mindset and execution behind creating compelling textures now just download Substance instead, drag and drop some materials on, and don’t take it any further because they don’t know any better.
Unless they’ve added in literal Photoshop to Substance in the year since I’ve tried it, it still doesn’t compare to being able to go into your texture image and manipulate it exactly the way you want in moments.