A few people have asked for recommendations, and I just spent months researching ebikes to buy.

Cheap and cheerful: Priority Current. Mid hub, internally-geared rear hub, upright position, cheap. Can get from Costco on fat discount for $2,600. Not a cargo bike, but amazing to go to the shops.

Longer-term: Specialized Globe Haul. I feel the same way about it as I do my pickup truck - it can go anywhere, do anything, and seems incredibly happy to either cruise around town or eat shit for hours. I absolutely adore it and cannot recommend it enough. It also has a big dealer network, something you don't get with the DTC boys. A steal at $3,500, but you can almost certainly get it for less at your LBS