Not a fan. As someone who has a porch, I would rather pay a delivery person to place the package on my porch (as has been done for years) than have a drone put the item in the yard where it is not protected from weather and is a rather more...
Had you actually read the article the OP linked, you would see that the drone(s) in question were operated over Los Angeles protests/riots by DHS, not the military. DHS is a federal law enforcement agency. Similar to the FBI monitoring folks.