yeah, the ones that pinch between the bb cup and the frame are going to put all the impact stresses onto the bb. specifically the threaded portion of it. You'll have less thread engagement to the frame than usual, so you run the risk of destroying your bb.
that one that clamps to the bb shell looks interesting. You'd want to make sure that you have enough bb shell to clamp to, though. I could certainly see some frames having welds that come too close to the end of the bb shell for there to be enough left to clamp to. And it looks like the mfr comments on that possible trouble. Me, personally, I'm not sure I'd be comfortable filing the adapter to work around welds. Though doing so will give you maybe a little extra help preventing it from rotating. Not that you'd run into major safety/injury issues if that adapter failed on you since it's a noncritical part.
I'd just rather use a chainring mounted bash guard than go to hacking and modifying. The Wolftooth BashSpider is a pretty elegant solution. It won't really prevent you from folding over a chainring in an impact (I saw that happen to a guy once, on a log, not a rock) the way a taco bash can, but it'll at least protect your chain from getting beat to hell.
These days, I won't even buy a frame unless it has ISCG05 tabs.