There's a lot of fancy stuff going on here, so I'm about to balance it the other way.
My forts never last long, they either get necromancer'd (army troubles, usually) or I dislike the design or just want to try out a new design.
And here's a fort that doesn't particularly represent any great achievement, but it does have the main idea of what I try to achieve.
The room on the left is the barracks (note archery targets in use!).
Due to anecdotal evidence that marksdwarfs train better when the target is in the barrack I've cut alcoves into the walls for targets. Looking at this design I realise I might use it later for a dining hall/bedroom combo, with the main barrack being the dining hall and each alcove being a bedroom.
At top is the trade depot, in the near future I'll be giving it its own exit with bridge.
But the main point is how I spread out the stockpiles.
I've tried 7x7 rooms with a workshop in the middle, I've tried workshops on one layer with stockpiles below and I've tried a central through-way with workshops on the side and then stockpiles behind or under the workshops. The last one was nice, it had a bit of a busy mountain hall feel about it, but I realised that big open space took too long to carve out, especially in rock, and was completely unproductive.
I tried filling it with statue gardens, zoos, tombs, dining rooms, but the logistics of that didn't quite work out.
So then I stuck the stockpiles in the through-way! And for now, I'm happy.
(A z-level above the barracks on the left is the entrance which is encircled by a guard house. My defences are pretty rubbish, but for now I'm focusing on getting a functional army up and running as soon as possible. Once I master that I'll move on to the more exciting designs. I build the guard house from logs as soon as I arrive; the idea is to get a system going that I know will work for the more Fun! fortress locations.
On the other levels I have bedrooms, dining halls, etc., but they're not worth showing.
I am yet to find any ores.)