Small Suggestion from me.
Basically right now we have crazy dwarves go berserk, which is really bad, and going melancholic or batshit insane. The latter two options don't really bother that much, or in fact differ little from each other in consequence. The mad dwarf is mostly harmless until he dies of starvation just like a depressed one.
My idea to change this and add some more potentially Fun! moments would be to make an insane dwarf act up for his namesake, insanely.
A dwarf that goes Stark Raving Mad will once again go running around tossing his clothes of and instead of succumbing slowly to starvation he would make a mess of your fortress.
The guy runs around hauling stuff that does not require hauling, occupying workshops to make some useless crafts out of his own feces and most destructively, pulling levers that are not designated for pulling. This minor inconvenience would make fortress designers a bit more careful about placing their doomsday levers out in the open.
Players might feel nessesary to confine or euthanise these dwarves, though others may find it amusing to keep them accommodated. The would make good jesters on a nobles court or possibly inspire philosophers. Giving them a random chance of producing masterful items would also give keeping them around a point.
I for one can get enough of random comedy moments in this game. The more things that induce them the better.