I think it's different for everyone and, in part, every genre. When an artist ceases to be an artist and becomes a parody of their former self, it's time to stop.
this is the closest thing we'll see to an answer to this question.
but even then, it hinges on whether or not they CARE if they look ridiculous.
if the music is still good... rock on my man.