Rocket missing a military target sometimes means a rocket incidentally hitting a civilian object, so not good. All kinds of rockets and drones are used to hit targets in all major cities. They’re not only used for some standalone objects in the middle of nowhere.

I enjoyed https://asimov.fandom.com/wiki/Cal as a kid (beware of summary here covering the whole story to the end)