you got some pretty good points here. I agree with you especially on anti-cavalry balance. In other civ opus, an anti-cavalry unit, beat the horsehocky out of cavalry, and that should be it... in civ6 i just spam cavalry and regular unit, these previous ones are close to useless for now since they are weaker against other than cavalry and barely do the difference with these ones.
Everyone should agree on the scout & recon unit (and even submarines) ignore zoc, this should be vanilla srsly and there is already a mod for this i don't know if you saw & i can't play without it, cool to see you agree aswell.
In the end the biggest failure to me, is that the mecanized infantry is the most powerfull unit of the game (speaking overhaul stats/matchups)... this doesn't makes sense at all, a modern armor should be kicking its ass (and when you take a look at production cost, this doesn't make sense at all again) this is ******ed to see everyone spamming mecanized infantry in the end, these one beat the horsehocky of almost everything, i had sometimes to sacrify 2 modern armors to beat one, and they are very easy to upgrade from infantry... cities become easier to take with m.infantry than you armors or else, i think there should even be a nerf ! c'mon firaxis in real life a mecanized infantry is just a fair armor with soldiers inside, yes it's powerfull but a tank shell aimed right here and poum ! only ashes remains.
Helicopters are not enough powerful i think, i tried many times, i don't build them anymore... but in real life helicopters are damn armor killers, they should be the counter of modern armors... somehow we need to make them more usefull than their mobility (and yes you are right again : 4 movments wth !!!)
and yes aswell for the destroyer sight + movment, (i think there is the sight of the cruisers that is 2 aswell, the simple one, not missile cruisers, they should have the same sight than their range no? they don't even have a promotion to increase their range, where destroyer has it lol...)