Yes! I’ve actually written papers about China’s “Green Wall” initiative back when they were doing trials for it and watching it actually succeed feels amazing. These sorts of large scale projects are certainly possible but any large scale project will also have large scale impact. I know one thing that hasn’t happened with the green wall initiative that was predicted is that it HASNT increased rainfall, and as you’ve said this has had an impact on ground water. As for these projects elsewhere in the world, some will have water issues and some won’t. It really depends on where they are happening.
One very scary example, at least to me, is that many places in South America that used to be rainforest but were clear cut for farming simply no longer have the moisture or biodiversity to support a rainforest in the area. Many of these cycles are self-perpetuating, which is what China anticipated happening but unfortunately didn’t.