Check out Boatmurdered for a look at how a dwarven fortress spirals into amazing and beautiful chaos: https://lparchive.org/Dwarf-Fortress-Boatmurdered/Introducti...
That version is very, very old however and doesn't reflect current gameplay style or mechanics, however the stories still unfold pretty much the same way.