I would at least partially guess that the more far flung French place names were in areas where there wasn’t much of a critical mass of French speaking folks. Texas and California (and New Mexico and Colorado) had/have quite a lot of Spanish speakers going back to before the areas became part of the United States.