And, Or, Not are very good if you have one(for not) or 2 boolexprs you want to execute back to back and dont want to suffer overhead from trigger creation and deletion. Other than that, they are useless garbage.
As PNF said, or, and and not work on booleans, so true, false, !=, ==, ... and Or, Not and And work on boolexprs, so basically on functions