The biggest delivery truck traffic is for furniture, goods (one or two UPS trucks for an entire building), or garbage. No amount of drone tech can reduce/eliminate truck traffic for an entire building.
The actually realistic solution is to focus on developing housing and infrastructure in the outer boroughs; Brooklyn and Queens are full of the absolute worst kind of inefficient quasi-suburban accumulated sprawl.