I was thinking about an auto-resetting cave-in trap. It's pretty complex, so I'll also describe what happens too.
Level 1 is the top.
level 1:
+---- ----+
|%%pX Xp%%|
+---- ----+
level 2:
-+ +-
w| |m
-+ +-
level 3:
h
f
level 4:
-----------
pr
-----------
legend:
screw pump: %%
pressure plate: p
flood gate (or door): X
water: w
magma: m
hatch (currently open): h
top of obsidian rubble: f
obsidian rubble: r
1. A hatch closes between a wall and the top of a block of obsidian rubble (or whatever remains after a cave-in).
2. A pair of doors open.
3. A single unit of water and a single unit of magma are dropped from the doors onto the rubble.
4. The lava hardens into obsidian.
5. The doors close.
6. The screw pumps turn on until the spaces above the pressure plates are 3 units deep.
7. A dwarf must be sent to clear obsidian rubble (the obsidian above it is left on top). This step can be done at any point.
8. An enemy walks onto a pressure plate.
9. The hatch opens, leaving the obsidian wall with nothing holding it up.
10. The obsidian wall falls next to the pressure plate.
Unfortunately, if the wall falls onto the pressure plate, it will destroy it. Fortunately, it will knock the enemy unconscious so they can be killed easily.
Setting up the computing is left as an exercise for the reader.
I also thought of a fishing area.
level 1:
S
level 2:
+--
h|FW <evaporation room>
+--
level 3:
+---+
|www|
+---+
legend:
same as last time with added
Water source: S. The entire first level can be a river; the point is that this is where it goes down. A hatch can be added if this goes to fast. This would be connected to a pressure plate in the evaporation room.
Floor grate: F.
Wall grate: W.
The idea here is that fish could come in through the water fall, but not go out. This way, when someone fishes there, there'd be tons of fish. You could modify it so you can drain the water out and just pick up the fish after they suffocate, but the turtles would survive. You may want to add a room between levels one and two to take advantage of the waterfall.
EDIT: I thought of another one.
Lock down.
There are two basic ways to do it. The simpler one must be planned from the beginning:
Build a door on every room. Hook them all up to a single Main Lever. The room the level is in will have access to every room through an alternate hallway. Along that hallway, there will be a Room Lever next to each room to open a door to get in. When there's a tantrum have someone pull the Main Lever, the Room Lever for the room the jailer's in, and the Room Lever for the person tantrumming. After the tantrummer is arrested, pull the Main Lever and Room Levers again. This process should limit the damage of tantrums and keep the fortress from falling into chaos.
The more complex one:
Every room has a door to it. Every door is connected to a pressure plate. Every pressure plate has a Plate Door (normally closed) next to it, which is connected to a Room Lever. On the other side of the door is an area that can be filled or drained of water using two Main Levers (Fill Lever and Drain Lever). This area is normally filled (This is arbitrary, but I'm going to stick with one way for simplicity.) When the Drain Lever is pulled, the water will drain off of all the pressure plates. The Room Lever corresponding to the room that must be locked down is pulled. This closes the Plate Door. The Drain Lever is pulled again, followed by the Fill lever. Every door opens again, except for the one corresponding to the Room Lever pulled. After the jailer goes to that door, the Room Lever is pulled again to open it. The Fill lever is then pulled again to allow the area to be drained again on the next use.
The drain lever can either open a door or hatch to let the water out, or it can be linked to a dwarven atom smasher. If the latter is used, the Drain Lever doesn't need to be pulled the second time.
If tantrumming dwarfs can destroy doors, you can use hatches for the same effect. Just switch opening and closing.
I also thought of using the exploit that creates water with a screw pump along with the dwarven atom smasher to build an artificial river. It's pretty pointless, though. If the water creation exploit has been fixed, you can use an aquifer instead.