I play only with large units (my computer isn't tough enough for huge ), but the big difference in terms of strategy is that larger units deplete your cities' populations more, so you have to take more care not to build too many. Tactically, larger units are more unwieldy but better able to hold a battle line. I prefer larger units for this reason.