For any automation methods, one needs consistency. There is no consistency in typos, although one could use a regex match to anchor to some common set of strings.
So this clean up job will need manual overseeing and multiple queries, whether in Obsidian core search or in DV(Js).
I am mainly writing here to interest you in the following:
The files from the demo vault are Datacore queries with live filtering and options to group by various properties. Maybe the most flexible way to have a look over your files. You’d also have the ability to modify property values on the fly if you install the Meta Edit plugin.
You can set folders to search in and in the settings part you can add your own properties.
Datacore would need to be installed via BRAT plugin.
I will not ask for a wider set of common errors because I would then be tempted to provide a regex replacer solution, while I can’t foresee all cases and I wouldn’t want to rename just anything.