Not if there's a building destroyer about.
Except that misses the real issue. Trap-avoid means pressure-plate avoid too... and you said that you wanted something "more reliable than cage traps." So this won't capture a single thing that a cage trap wouldn't, and in fact will capture several LESS things. As Grak mentioned, floodgates are NOT immune to building destroyers. That would trap a common troll for mere seconds. It would be somewhat more realistic that a cage trap in that a dinky wooden cage shouldn't hold anything more than a small critter, yet alone a powerful warrior.
To trap a building destroyer you have to stun or web it first This is done by either having a spider spit web over the trap (by chaining a goblin or dog behind the trap), causing a cave in above the trap tile, or dropping the creature several z-levels on top of the trap (stunning it with fall damage). Now, some beasts are both "trapavoid," and "web/stunavoid" so there is little you can do about them in the name of in-game "traps." You can, however, seal them into rooms with raised bridges. Its how I make "zoos" out of titans and forgotten beasties
if you want to trap kobold thieves and goblin baby-snatchers, then your best bet is early detection. A pair of dogs on a chain near your entrance will spot them.