Even a kilogram of marijuana would be somewhere in the neighborhood of $10,000. Something like pure cocaine is worth vastly more.

For this to work in the longer term, the drone would need to fly high enough to be more or less undetectable from the ground, and a long enough distance so that it's impossible to monitor all available landing sites. I don't know enough about drones or the US-Mexico border to say whether that's practical.