As a parent of two children I know the frustration that you experienced and I can't write with honesty that I haven't had the same reaction. That written, the big picture is that you're the adult and one of the most formidable ways kids learn is by witnessing their parents' behavior.
That you posted here means that you have some regret about your behavior; we're human and don't always do what we rationally know is right so in an age appropriate manner express what you wrote here to your kids. They'll appreciate your honesty while also getting a reinforcement about how situations should be handled even if we don't always meet that high standard.
Reaching one's boiling point with kids is a universal experience even if one has never touched a drop of alcohol or any other drug.