Untrammeled craziness is a disastrous career move. But sometimes craziness, tactically deployed, can raise a recording to greatness. A look at the guest-star career of SinÁ©ad O’Connor, whackjob for hire.