I sometimes use a variation on the old "Goblin Grinder" trap
which I call a "Bee Door" after the one-way entrances beekeepers use to get all their bees into the hive. It has to be modified a bit because of increase jumping and climbing in 0.40.*+, but it's still simple. I'll admit it's been a little while since I built one, so if something new has made them not work, let me know!
Basically, the entrance is a short 3 wide. 3z level hall with all smoothed walls. The walkable path is one wide, and ends with a pressure plate set to ignore dwarves, which otherwise triggers 2 hatches next to one another. When a creature triggers the pressure plate, both hatches open, which ends their pathing. It's a good idea to throw a set of steps on the outside of the shallow pit, because accidents happen (and it eases construction.)
#############
.........................#
> ^HH + Z level 1
.........................#
#############
#############
.........................#
>.......................# Z level 0
.........................#
#############
############# # = smoothed wall
# . = empty space
> # Z level -1 > = stairs
# ^ = Pressure Plate
############# H = Hatch
They're great for installing as migrant entrances along the edges of maps, although of course they won't stop all creatures (fliers, trapavoid.)
As for adventurers, I couldn't say.