I'd say depends on the complexity of the logic itself. I would never write triggers with any logical branching, but for simple update table B when table A is up

I'd say depends on the complexity of the logic itself. I would never write triggers with any logical branching, but for simple update table B when table A is updated? I definitely see the value in that.