I usually ban people for a few hours or something if they're being quite mean to others, and have been told to stop.
I figure they may be better if they return when the others aren't around.
If they're going out of their way to disrupt, cause problems, or starting stuff with me, then they're gone for good.
But generally, it depends on the scenario. There are many different reasons I have banned people for.