I have extensive experience with PowerShell and am confident in my ability to assist with this project. As you suggested, we can export a list of folders requiring renaming, review them, and then proceed with the renaming process. Upon completion, we can automate a notification email.
To enhance flexibility, we can incorporate site URL and new folder name as parameters, allowing you to easily modify site names in the future.
If you're interested in moving forward, please reach out so we can begin the process