I came up with this idea when thinking about, of all things, dwarven football.
It would be nice to have more options for supporting rooms, especially with the z-axis coming in. Simple vertical supports are nice and simple, but sometimes you want a nice, big, open space, without supports every 6 tiles.
Some options:
-Arches. There's two ways to do arches. One is like a traditional support, as a separate structure (probably made of metal) that supports the roof. The other is to make the roof itself an arched shape, so that it distributes the load outward on its own.
-Rafters/cantilevers/horizontal supports. These run horizontally across the ceiling, or at some point below it with a support system running up to the ceiling, to distribute the load to the side walls. A well-designed rafter system could even use the rafters as catwalks in and of themselves.
-Diagonal crossbeams. These are like rafters, except that they run diagonally from the corners of the ceiling to the walls.
-Lots of combinations of the above.
Dwarves who are in a large room with an engineered support system could be inspired with a happy thought, the magnitude of which would depend on the size of the room and the engineering required to keep it up. ("He admired a large hall lately."/"He was impressed by the size of a hall lately."/"He was awed by the grandeur of a great hall lately.")
Something like this would likely require a fully simulated load-distribution system to calculate cave-ins and the like, rather than a simple check like we have now. On the minus side, this is quite processor intensive, and would probably be quite a bit of work to implement. On the plus side, the physics involved are fairly straightforward, and the system definitely would not have to be simulated every tick, but only every once in a while. (I'd hazard a guess that load distribution is simpler to calculate than fluid dynamics, for example.)