Industry has field-tested those too - pitched by Lockheed to the USN after USAF backed away but wasn’t purchased. Check out the LOCAAS.
I see the problems there. The first is that its warhead was too small at 17 lbs, designed to be an antitank, equipment and personnel weapon, rather than a stationary target attack weapon. Too specialized.
By comparison, the V-1 Buzz Bomb carried close to a 2,000 lb bomb.
In modern terms, the gliding Small Diameter Bomb performs more a role of what I am talking about, carrying a 500 lb bomb, but its heavy bomber delivery system is way beyond the budget of most nations who would want it.
So what I am describing is a ground launched SDB, with some primitive guidance, most of them carrying 500 lb bombs, a larger class carrying 1000 lb bombs, and peaking out with some carrying a 2000 lb bomb.