To my understanding SPES would not be applied retroactively, and the current mod team is showing a ton of leniency towards past offenses (within some limits...).
So about lengths for mixed and extreme offenses: Within SPES there's a tier thing. It allows for modifications based on circumstances.
- Tier 1: Things like users joking around with each other. No punishment.
- Tier 2: Either too many jokes that it becomes worrisome, or else a violation which is too minor to merit the textbook punishment.
- Tier 3: The textbook offense, yields the textbook punishment.
- Tier 4: An extreme offense, which results in skipping a step in the punishment chain; and enough of them can result in permabans.
Something like 'I want to slap some sense into you' would not be ban worthy; in fact it would barely be notable unless it's a repeated offense. However, in a fit of rage promising violence, clearly the person needs a time out. An actual credible threat of violence, that would necessitate greater than normal punishments; as would making a non-credible threat worse by bringing someone's family into it.
Regarding doxxing, it is such a serious matter... But I wouldn't mind seeing a little refinement to that section of SPES to clarify where the line is crossed. Someone guesses someone else is from Australia, it's certainly nothing we'd want to ban over. Other stuff is too mild, like 'hey are you the same dfss9788 from such and such a website?' which would clearly not be malicious.
That said, I'm not the architect of SPES; nor one of the big decision makers in interpreting the CoC now (which with the various complaints about me, and it being a move away from how I moderated, should be in its favor).