Hello Tommy,
as a "newbie" I hesitate to try to "answer" a question posed by an "astronaut" - but I've been struggling with various aspects of this issue for a long time in other contexts, and would like to offer my help if anyone actually decides to take on the issue of "standardizing locations across time".
Please also have a look at a question I posted recently on possibly using geo-data in profiles. If WikiTree genealogists were given the opportunity to enter geo-data and let "the system" assign the standardized location tag the WikiTree leadership decided was "correct" for the given date, it might reduce the difficulty encountered when asking millions of users to adhere to a necessarily complex description of how to determine and enter "standard" texts.
It should be pretty easy to communicate how to find and enter geo-data. Most users have access to the internet, and either what3words or latitude/longitude information is readily available online nowadays. Entering the geodata for the center of town, or the state, regional or federal capital would suffice (together with "uncertain" status) would suffice.
Geo-data for modern New Castle, with the appropriate date, could "automatically" result in the correct standardized category within New Netherlands, New Sweden, New York, or the state of Delaware. Perhaps even more importantly, using geodata would let genealogists recognize whether different locations (particularly counties) recorded in census records were the result of an actual change of residence or merely of the official administrative hierarchy.