Basically, with a “butcher” style bike, the weight is carried lower and hence more stable, but it won’t give you much more cargo space than a normal bike fitted with a large porteur rack… unless you go for something more dedicated to actual cargo carrying, like the small-wheeled Orbea (or similar, e.g., the Soma Tradesman, etc.) or something with a larger platform (and probably a steering linkage).
https://www.somafabshop.com/shop/product/soma-tradesman-frameset-orange-5424?category=990
Another option is to fit a Crust Clydesdale cargo fork to a normal bike.
But then the weight is on the fork and therefore negatively affects the steering. Probably the worst option in most ways.
https://crustbikes.com/collections/forks/products/clydesdale-cargo-fork
A normal bike can carry a lot (although maybe not optimally, unless you go for a heavyweight Dutch roadster).
Butcher bikes have similar capacity, but may (or may not) carry that load slightly better (if the geometry isn’t sorted, that front wheel can be squirrely).
And dedicated cargo bikes are great at what they do, but can be overkill for everyday use (and not well suited to the appalling design “standards” of most of the narrow, tight, crap UK bike infrastructure).
Horses for courses…