Best terrain texture generator / shader

I am looking at generating a high detailed terrain texture that looks something similar to this (a sandy, rocky terrain)
I also need it to blend with a terrain satellite map (4096 texture), unfortunately the texture is of relatively low resolution and thus trying to fill in the detail at lower levels

I have seen some assets in the store that look good, however I am asking here for a list mainly as the ones I have found also come with a lot of other features that I doubt I would use eg. terrain editing, overhang/caves etc or (from the screenshots) don't have the fidelity I am after / have horrible tiling, with that said I understand this last part would be greatly impacted on the art/artists too.

One feature that would be nice, but can look else where is for real-time terrain blending for meshes

Thanks for any suggestions