@Tatjana6 Yes I have. I had a guest who drove drunk, ran their car into my neighbour's yard, then got into an argument with the police. Good times!
I guess it depends on what you mean by "behaved offensively" and how it made you feel. Was it a health risk? A security risk? Did you feel unsafe? If the answer to any of these questions is yes, maybe it's time to end the guest's stay.
If it falls more into the category of annoying behaviour and you feel safe to do so, maybe speak with the guest once they're sober and let them know that their behaviour was not acceptable. If you're not confident doing this in person, send them a message through Airbnb messenger.
If the stay is already over, I would at least write a review. You don't need to go into the dirty details, but let people know that you wouldn't welcome this person again.