Maxwell's Silver Hammer by the Beatles. Maxwell was a psycho, but to a jaunty tune. Excitable Boy by Warren Zevon--this was another psycho and another jaunty tune. The Pretenders, Thin Line Between Love and Hate about domestic violence and revenge.

You're right, the list could go on and on....