its an issue that has been around civ for a while. its super frustrating indeed.
however, don't forget that relatively primitive units in Vietnam and Afghanistan held out against super powers with advanced weapons. i realize in both cases that the primitive folks had access to some pretty advanced hardware, but i still think it can serve as a reminder that sometimes people can overcome odds.