I am looking at exactly the same thing.
I currently have a SWB FWD Transit but that only has a maximum train weight of 3500kg so doesn't have enough capacity to tow a 1200kg car + 500kg trailer + 180kg driver/passenger + 100kg tools wheels etc. = 1980kg.
I have been looking at a ford ranger as that has a maximum train weight of around 4500kg and weights around 2000kg so should be enough.
I have also thought about changing my van to a SWB RWD transit as that also has around 4500kg.
my van is currently my everyday vehicle and is converted to a campervan, but this will be going to finance any new tow vehicle.
just cant decide what is the best option is.