Cargo bikes (both manual and electric), smaller electric propulsion carts, and similar hardware solve for this trivially. They're also cheaper than light autos. Woohoo!
https://pulse.dbschenker.com/eu/xxl-cargo-bike/
https://www.bicycling.com/bikes-gear/a25054215/best-cargo-bi...
https://store.graniteind.com/category/power-carts/indoor-out...