I think a human needs to be in the loop to make the right choice between abandoned communities and communities preserved for posterity.
The best balance might be to empower the instance admins with an easy, push button solution to list inactive communities by last activity for bulk deletion.