Mines a 2016 so no AWD option then. It has a LSD which can provide a little help off-road. I put BFG T/A KO2’s on it and they’ve been great. It has the 3.5L EcoBoost and I’m glad I got that. It’ll move out when you need it to and has been a great tow vehicle the few times I’ve needed to haul heavy loads. They can be amazing recreational vehicles with a few limitations. I hunt, fish, camp, haul dirt bikes, and take family trips in mine. I installed a two person passenger seat in it for when I need to haul more than just two people. It’s on l-track so I can position it farther forward, backward, ,face it rearward, or remove it needed.
If you don’t over ask of it, it will handle some off road. The suspension and, even more so, the ground clearance are more limiting, IMO, than lack of 4WD. On the transit the rear shocks hang low and the mounting brackets 2” lower than the shocks. There are aftermarket mounts that can help there. The KO2’s (225/75/16) add an extra inch of height. As far as milage, I used to see about 17mpg on the hwy even doing 70+ mph. For some reason that dropped into the low 15’s. It only has 25k miles on it. With bigger tires mpg will take a small hit. The Transit drives very comfortably on the road. In high winds they can toss around some. Mines a medium high roof which adds to that. But being able to stand up inside makes it worth it.
If you are handy the skies the limit on building out the inside to meet your needs. And it is great to have your stuff secure inside and also protected from the elements. Being able to sleep comfortably in it is awesome. You need a floor, insulation, and airflow/circulation at a minimum to make them truly comfortable. Otherwise, in cold weather, condensation builds up and freezes if cold enough turning it into an ice box. Hot weather makes them an oven without insulation and some airflow. Lots of owners install a roof vent fan for that. You just have to be brave enough to cut a big hole in the roof of your van to install it! Even though creepy, white keeps the inside temps down considerably from other colors.
Overall I’m glad I went the van route. I just loaded up my dirt bikes and gear in it tonight to go riding in the morning. Nice to have them out of sight not attracting attention while they sit in the driveway overnight.