I don't know if it would improve MPG, but in my 93 F-150 it came stock w/ automatic hubs. Worked good for the most part. But they do fail. Mine went and my local shop put manual hubs in, and I never had a problem after that. W/ Manuals, it is essentially fail safe, meaning you'll always be able to lock them in unless there is a part broken in the hub, w/ automatics, more things can go wrong and it may not engage the front hubs.
If I ever have the choice again, I will get manuals put into my vehicles. My local shop at first did a free swap of auto hubs because they had some many laying around since a lot of people are getting automatic hubs at the dealership and they swap to manual hubs right away. It sucked when mine went out, I was ice fishing and backed my truck down the boat ramp to load up the gear we brought out onto the ice (it was barely driveable so I chose not to risk putting the truck through the ice). After we loaded up, I could hear the gears grinding and slipping in the front hubs, I had to back on to the ice and floor the truck up the ramp to get up it. Luckily the ice was thick enough so I didn't go through.