Was Pinchus a psychopath?

In the book of Numbers we read about the heroic actions of Pinchus who avenged God’s fury and murdered a Jewish leader who was publicly fornicating with Midyanite woman. The Torah accords him with much honor for his courageous acts. What is the deal with this? Are we allowed to take the law into our own hands and mow down sinners?