I think it's safe to say that everyone would like a hauling overhaul. It generates an absurd number of jobs and dwarves handle it very, very stupidly.
I would like to see several more stockpile options added, this is just one of them. Here's what I would like to see:
Allow/Disallow Full Bins - allow by default. If disallowed, full bins generate a hauling jobs, assuming there's somewhere else to put it.
Allow/Disallow Less than Full Bins - allow by default. If disallowed, then empty/partially full bins generate hauling jobs, assuming there's somewhere else to put it.
"Mark for Melting" - any non-bin object held on the stockpile is automatically marked for melting once it gets there. So you can set up a stockpile that only accepts goblinite, and it automatically gets marked for melting.
I would say auto-dump orders as well, but with quantum stockpiling, that would get pretty ridiculous. Once dump zones work differently, this may be worthwhile to consider.
Expanded "Take From" options - namely, allow multiple stockpiles to take from a single stockpile (i.e. have 3 food stockpiles take from your master food stockpile near the farms). Jobs would be worked in order of proximity, as normal (i.e. the nearest secondary stockpile would fill first). This would mostly be useful for having multiple specialty stockpiles pulling from one general stockpile (like a steel stockpile next to a forge pulling from the master bar stockpile, whilst a gold stockpile next to a different forge pulls from the same master bar stockpile).
On a similar note, workshops should both be able to issue and be subject to "Take From" orders. This way you can always ensure that you're making mechanisms from bauxite and thrones from obsidian. If the workshop order cannot be currently fulfilled by the contents of the linked stockpile (or workshop!) then it should be temporarily suspended until such time as there's sufficient supplies, at which time the order would be automatically unsuspended - perhaps it would cancel the order unless you have a manager, who then has to approve the unsuspension. This would make managers more useful to those who don't utilize orders (such as myself, given that I'd much rather overproduce so I can just stick the order on repeat)