As one of the world’s most influential bands prepare to bid farewell with a huge show at Villa Park in Birmingham, Roisin O’Connor speaks to just a few of the musicians whose lives were changed by the Prince of Darkness