@Ben
Depends on what emissions level one is comparing to.
If its a non-emissions compliant, modern common rail engine (say a model intended for Chile, a region with clean fuel and no off road emissions requirements), then there is no way to beat that combination of modern fuel system and no emissions targets on fuel economy.
But if one is comparing to a previous emissions level, where its the same fuel system but also adding an urea SCR system, then yeah, it can be an improvement. The urea consumption sometimes offsets the fuel reduction, but I've worked on several cases where it was a net improvement on total fluid consumed compared to the previous generation engine design.
DPF's are going after PM, which is completely different emission item. Urea SCR targets NOx. Part of the reason why your DPF is taking more fuel is because the engine requires dosing the exhaust with raw fuel to help heat up the exhaust. The hot exhaust will cause the soot (PM) caught in the filter to oxidize into CO2. I suspect that your dosing fuel consumption is awful during the cold days of winter months. Its trying to heat up all that exhaust!
Here is how a urea SCR can make a net improvement to a DOC+DPF equiped engine...
By adding a urea system, the engine design can use more advanced or earlier injection timing and higher injection pressures. Both setting changes increase NOx and reduce PM. Therefore, the NOx is being cleaned up by the urea, and advanced timing is good for Brake Specific Fuel Consumption. With the reduced PM, the DPF won't be filled as quickly = less regeneration needed = less dosing and fuel consumption. With increased NOx to PM ratio and a catalyzed DPF, the PM can also more easily passively oxidize without any extra heating at all, again a dosing and fuel consumption reduction.
In summary, here is how a urea system can actually end up net better on total "fuel" consumption... advanced timing for improved BSFC, lower PM production and improved passive regen causing reduced fuel dosing.