In my experience, the ability to let users delete their accounts is not very useful, and it's tricky to implement (do their posts disappear? Can their names be reused? Do threads they started disappear?
I'd have to be asked really, really nicely to delete posts belonging to a deleted account.
Except in the case of spam, I trust.