Delete comment activity when comments are deleted, trashed, or spammed

See #787