I don't like deletion. It makes the site worse, obviously. But I don't want to annoy artists, either.
Everything should be soft-deleted. Very few people should have the power to immediately and irreversibly delete anything.
We should go to great lengths to discourage deleting art—or, rather, encourage keeping it. Why do artists take their art down and what can we do about that? Dislike of the site, bad reaction from the userbase, dislike of old art...
I'm tempted to just forbid deleting CC art or something, but I doubt that'll go over very well. Maybe there's room here for having art still marked as by you but not actually in your gallery. Or maybe this can be covered by clever use of albums... which is another ticket.
Right, well, this will happen eventually.
I don't like deletion. It makes the site worse, obviously. But I don't want to annoy artists, either.