The reason is simple. We have a lot of packages that reuse content of a user (take forum postings for example). If a user has started a thread and you do a delete on cascade, you delete the start of the thread and with it all messages that use this thread as the parent_id. So in effect you delete a lot of content just when you want to delete a user. The approach described by Roc is therefore the one to choose.
