In most cases, the vacuum that the engine works against (cylinder pulling in air) is created by the restriction of the throttle body valve.
There are 2 scenarios we need to consider:
1. When the TB valve is 0% to 50% open. This is where most of us spend our time on the highway, cruising unloaded and towing nothing. This is the region where daily MPG will come into play. Under this scenario, the valve is more of a restrictor plate in the air flow and is the most restrictive object in the intake tract. Because of this, modifications to filters etc. do not give much effect to cruise MPG, since the TB valve is this largest restriction. Engine vacuum is not changed in this scenario.
2. When the TB valve is 51% to 100% open. This is the region where we do our accelerating. Most of our city driving is affected by this. Also while towing or loaded down, or going through lots of hills or mountains. Under this scenario, the valve looks more like an airfoil or a aero vane in the flow. Depending on other restrictions and the amount that the valve is open, it now may NOT be the most restrictive object in the intake tract. If you have a heavy foot, or do a lot of towing/hauling or generally live in an area where there are a lot of hills or you spend a lot of time in stop/go traffic, you MAY see improvements to MPG as well as power if you remove restrictive objects before the TB like filters, accordian style piping,etc. because this will now affect the engine vacuum seen at the cylinders and will improve overall efficiency. Even though you may use a bit more fuel, less HP is being used to pull vacuum and is freed up to power the drivetrain.
The V6 does not benefit from the improvements in scenario #2, simply because the whole engine has been designed to provide low end torque. Because it is a V6, the design considerations required to accomplish this restrict air flow throughout the engine via specifically designed intake manifold, heads, cams, intake/exhaust valves, and exhaust manifolds, which in turn significantly impacts the engine's ability to flow more air at higher RPMS and compromises peak HP. The point is - the V6 engine itself is more restrictive to airflow than even the TB valve. This is why it is hard to get good HP gains out of the V6 unless you improve volumetric efficiency by addressing the items designed to improve low end torque...
V8s in general do not have a problem generating low end torque because of their inherent larger displacement.