We have released a new CB Plugin called DT Delete Me! This CB plugin adds the ability for your site users to delete their own account. That's one less maintenance task off of your list! Delete Me will add a new profile tab including a Delete button and a customizable message. Admin is notified of the user deletion and the user is logged out then sent one final email to confirm, which is also customizable. For use with CB 1.2.x and Joomla! 1.5.
We have updated this plugin today to resolve the issue of the Delete Me tab being visible to other users. Although other users were not able to actually delete someone else's account, it was still showing. This is fixed so get your updated version now.