Many performers hated playing live. But freed from the stage they often made their best and wildest work, argues Graeme Thomson