I would like the learn the Russian Shahed's price, success rate against defended stuff and accuracy. 40 kg is definitely not enough if accuracy is not superb. The Mk-81 was withdrawn from the US service because its effects were found to be not enough. Even the JDAM kit for it was canceled. 125 kg class bombs only returned to the US service in the form of SDBs, a purpose built gliding bomb with a very sophisticated guidance package. The recent ones, in some conditions, achieve a sub-1 m CEP. If the Shahed's accuracy is like 10 meters with that 40 kg payload, then it would be too weak for a lot of things. And if adding some more accurate and jamming-resistant navigation bumps their price to 100k or so, why not just build more CJ-10s then? It would terrain hug at Mach 0.8 and deliver a 500 kg warhead within meters. I would take that over 6-8 Shaheds anytime.
I think Shahed-type ammo is useful within rocket artillery distances. I mean sub-300 km by that. At that distance communications are easy, you don't need to fly for hours over deep enemy territory, etc...
Here is the Harop. The Harpy was among the original loitering munitions and the Harop succeeded it. Man-in-the-loop, good control software, ESM and IR, etc... Limited to 200 km by communications. Costs millions. Israel's concept for kamikaze drones was a bit different. Rather than cheap cruise missiles, they are more like loitering and situation-aware weapons that can be deployed to places where a threat can emerge. No deep strike or facility destruction purposes were considered.