2
I agree in part. Some times users request account deletion and I have to ask them to delete their news entries, photos etc first. News have copyrights and I cannot have them as 'anonymous'.
Problem is that I should not do it in database. News have comments, tags, files, notifications, etc associated and deleting just the news items would leave a lot of trash.
I think that modules should provide an 'on_user_delete' function just has they do for 'on_install', 'on_uninstall'
But, this is not mandatory to be included in the core. A module could be built for this propose. I have the opinion that core should only handle what a module can´t.