As a new musical verison of Thérèse Raquin comes to the London fringe, Dominic Cavendish reflects on the history of the dark musical