When we did the migration at one customer, we had the same issue - the users were highly using the public/private folder to manage their reports.
We then design it the following way:
From the public reports:
only the project + core team can manage it and create folder/reports
the public reports structure has a main folder with identical structure for all our business (spend/contract/sourcing ... folders) + a link to a public sharing points report
The public sharing points report is a placeholder for each business where all users from the business can save reports which they want to share with others.
Super users from businesses can create a folder with their name to manage their reports
we also built a scheduled task that runs once a month and archive all reports from the root into an archive directory in the project so it does not look like a mess when we open the project document tab
3. which SP are you on ? I believe that has been handled by ariba in a later SP, else in the meantime we did add the MyTitle field in the table options so this field was sortable
Did you ever find a way to delete or deactivate public folders? If so, were able to delete them in mass? We have over 1000 public folders and each of those has default reports stored within them. I can delete a folder but it is very time consuming because I need to first delete all the reports and sub folders before I can delete the high level folder that is assigned to that user. Any help would be appreciated.
I ended up creating an "Archive" folder in the Public Folder project and moving the public folders for inactive users there. It's not an ideal solution, but at least it shortens greatly the main list of public folders that you have to sort through.
Hope that helps.