At some point in the future I would actually like to be able to create some really fancy thing like this:
This grand bridge was masterfully designed by Mistem Tostivdon. Its 12 onyx pillars are banded in gold, and were engraved with masterful images demons making a submissive gesture by Erib Daskabouz. 4 moonstone towers hold the control mechanisms to raise the steel deck. They were exceptionally engraved with images of dwarves and dogs by Thikton Sausabrau and are topped with platinum idols in the form of dragons.
Materials needed would be 48 onyx blocks, 20 steel bars, 12 gold bars, 12 moonstone blocks, 8 stone mechanisms, 4 platinum idols.
I see that as something in the far future where we all we say is put a bridge with these dimensions here, and this is the maximum materials that can be used. Then the dwarf with the architecture skill actually decides what is needed and chooses all the materials within the list we have said could be used.
Another thing that would be needed for this is to be able to overlap all sorts of things. Ordering dwarves to engrave a bridge. Placing a stockpile on a bridge, rush hour traffic creates car stockpiles on many bridges in our world. Making a brdige then creating a channel under it, or just putting one up over an empty channel. Bridges and roads with slopes. For that matter I don't want to use ramps in the new z-axis, I want make bridges as my ramps so I can set a raise or retract form for them.
There are many things that can be done yet, but just having a consolidated list is a huge improvment. I am very confident that Toady already has a lot of ideas to make some of the crazy stuff I am saying a reality.