Gearing can always be changed and I'm not sure about the heavy.
Sure, they weigh more than the first two options in the list, but heavier than those options that come after it?
I rejected an Elephant Bike on weight, but I'd have to carry it up and down stairs every day so would have rejected any other cargo bike as well. I don't think there is anything else comes close in terms of filling your needs and value.
OTOH if you have enough use for one they all seem to offer plenty of value, if your use is more casual, well you probably already know the answer's a trailer and all the objections to that you've raised are easily put aside.