Yeah, not to be repetitive, redundant and reiterative, but as there's next to zero chance of successfully making this a fully automated process, a streamlined/assisted manual review and touchup would cover all the bases in the most efficient and "best outcome" way.
Or... you could play Ellis Island agent and just shorten any name that doesn't fit your standard typography! 🙂
(Not to propagate the urban myth here... no immigrant names were ever changed by US immigration.)
Yes, of course - script would be only 1st step.
And even if you can automate "only" 50% - it's half the time saved...
But then, with a right script - you can speed up your work even more - if you won't have to use mouse to select the problematic instances...
You could use just keyboard - use arrows to switch between those problematic instances - and use keyboard shortcuts to do something - squeeze more in any specific way - but you save time on mouse clicks...
I've done something like this few years ago for the Polish Patent Office - as part of a bigger solution - there was a lot of few rows tables - and columns there had to be resized individually to better fit contents - reduce number of rows, same as on this case - script allowed user to use up/down arrows to switch between tables - and left/right arrows to resize columns.
WAY quicker than constantly switching using mouse...