Ok, I am attaching three manufacturer's data sheets, one for a NA Detroit 6-71 another for a Cummins 6BT 210 hp engine and the third for a Cummins QSB 330. The first two produce about he same wot power and the Cummins 210 at least is a popular trawler engine.
Looking at the N55 injector DD engine which would be appropriate for a 40' trawler, it burns 4 gph while producing 60 hp (as well as I can read the curve), again a reasonable displacement speed hp for a 40' trawler. Now look at the Cummins 210. It produces 60 hp while burning 4 gph, the same as the DD.
The two engines match well at 160 hp both burning about 9.5 gph.
The Cummins 6BT is a generation behind current and the DD is at least two generations behind. FWIW the current generation Cummins QSB does better, burning a bit less than 3.5 gph to make 60 hp, probably due to the more precise, clean burning injection system.
So the best you can do to beat a DD is with a modern, common rail QSB and even then the real difference is about a half a gph.
There are other good reasons to repower a DD based trawler, but fuel consumption isn't one of the better ones.
David