If we denounce the artist, then what becomes of the work that remains? The #MeToo movement is overturning a cliché that has forgiven bad behaviour for years: to be creative is to be prone to eccentricity, madness, addiction and excess. No longer can artists be excused from the standards of conduct that apply to us all