I am a lazy boi and just use the schemes from the citadel paint app for just the dirt parts. Or I get resin scenic bases as I really could not be bothered doing anything super custom.
The Citadel schemes are often pretty underrated. I remember going out and paying for a White Dwarf just for the section where they gave several examples of how to paint each Texture color they sold and for different battlefield styles. They do things like recommend a drybrush of Underhive Ash (a pale yellow) before drybrushing Tyrant Skull, and it really makes all the difference compared to when I was just winging it and drybrushing white or bone or even Tyrant Skull alone.
I'm using that scheme myself on armageddon dunes for my sandy bases for my Blood Angels in the ETL. Except my underhive ash has turned to rubber, so I substituted krieg khaki - same colour, just an edge (now layer) paint instead. But I like to add more than just the texture paints.
In my case, I mostly use negative impression pads called basius - you put greenstuff on a base, press it onto the appropriately themed pad and hey presto, custom textures. Cheaper than resin bases, and much more variety! Shame they don't sell them at retail any more, but there's been several kickstarter versions.
This is the one I'm using for my BA:
Greenstuff world do textured rollers than work on the same principle, but the range is much more restricted to repeating patterns.
The downside is getting the edge right, i.e. trimming and smoothing where the greenstuff meets the rim can be time consuming, so I just fill in the gap with texture paint and drybrushing, and blending it into the existing rubble/sand on the base, and paint as normal. I could use sand of course, and in this specific example I am adding some gravel to add some small rocks, but the textured paint looks better and saves painting time, so eh, just call me lazy.
Literally hot off my painting table, still needs a extra coat on the rim I think, but you get the idea.
The WD article on different tweaks to the texture paints you reference is super handy, definitely, I have the magazine somewhere, though I usually use the digital version...