We’ve just done something similar in the last 2 weeks. We went from smax to transit double cab in van. We went for the limited as you got more toys and the double rear doors were essential. We went SWB over LWB, but that was our preference, as we wanted something that could still fit a standard parking space easily, but the compromise is front wheel off, but have already 3 adult and 2 kids bikes in the back. so far very impressed and far cheaper than an equivalent aged galaxy.
Put off by VW by the VW tax, mainly single rear door, lack of bulk head and an equivalent VW to ours was 8-9k more expensive 2nd hand, but we think we have got a non-vat bargain.
Vauxhall / Renault traffic seemed to lack refinement, but was very tempted at one point by the new Berlingo / combi-life LWB. But wife didn’t like the gearstick placement.
The Nissan nv200 was very nice – but nothing on the 2nd hand market. Mazda i800 worth a look.
My only advice is that dealers seem to struggle with non-vat vans, so may be worth a gaggle.