Lets define a couple things:
AWD: All 4 wheels have power, all the time.
4WD (4X4): You have a shiftable transfer case that is 2wd most of the time, but you can engage 4wd when needed.
4WD is what you want. I had a jeep with AWD, it sucked. They are useful for soccer moms who have no idea how to use a 4x4 button.
Pick a Ford pickup truck in the configuration and hauling capacity you need/want and be happy. If you want a serious people mover, I am liking my Excursion. You may not like the fuel mileage of 11.9
. They also quit making the Excursion, so you are limited to the used market. They bring a premium around here because of that.
I would advise AGAINST the ecoboost. I know a couple of people with the F150 ecoboost, they don't get the mileage. They do make impressive pulling power, but if you want more reliable, KISS.
ETA: Get a vehicle with limited slip axles, or have a limited slip/locker installed in the open diff. I won't go back to open axles after having limited slip.