Completely Agree - I was carefully planning using Storehouses, Overseer's Offices and Shrines of Fortune and could barely get by.
Then in another game, I just created 3 prisons and that was enough for me to just load my dwarfhold with fully-housed cannon outposts, just one straight ladder going down, and on each layer 2 outposts and a dorm. That's 150 ranged attack per layer with no reset cost between combats. All sourced by prisons, and my resources would just be capped constantly.