I chose on release simply because it is a baseline with easy equivalencies without needing to factor in where in the DLC cycle we are at. CIV VI had a lot of DLC interspersed before its first expansion, while Civ V had similar add-ons before its first expansion. Minimizing variance seems important when trying to make fair comparisons.
I mean, if we want to see the increasing pattern, we should look at the whole picture. You want a comparison, but I want to show you an increasing pattern, and the fact that the game had a specific percentage and then it increased with time clearly supports the idea that there’s an increasing pattern.
The broader pattern that I am seeing here is that women have historically been underrepresented and as has been seen over the past several months, the very notion of adding just two more women in than the last game leads to post after post of people losing their minds over it. Many times these posts create their arguments off of points that have no basis in reality and no basis in the history of the Civ games (despite all of these posts claiming to be from long-time fans who just want Civ to get back to "how it used to be").
I'm not going to really engage with the critiques on Gorgo and Catherine de Medici here since I am not a historian (just a fool who is interested in history), but I will say that it is always interesting how under the microscope women leaders are under compared to their male counterparts.
I’m aware that there are probably other posts with little basis in reality — I’m sure they exist. That’s why I shared the raw percentages, so we can discuss the objective numbers instead of opinions.
About the “microscope” you mentioned: it’s totally fair that you like it. In fact, I think many people nowadays share your perspective, which is why so many companies have recently started catering to that preference. I just find it impossible to say, “you’re wrong because you like something I don’t.” That’s why I was a bit surprised by your previous post, where you seemed to suggest that Bug Repellent’s post "was wrong simply because he liked something you don't" (I know you've not wrote it directly, but to me it seemed the "subtext" of your message, you've even called him in bad faith).
Personally, I’ve felt forced to see Gorgo instead of Leonidas — just like I’d feel forced to see Queen Victoria’s husband instead of Victoria herself. But that’s just a matter of taste and it's perfectly fine to prefer Gorgo.
Looking back at Civ VI it is interesting to me that certain choices such as Philip II have never been under such scrutiny despite him having been someone who took power at the peak of the Spanish Empire and who oversaw its decline. There are many reasons associated with this some entirely his fault (such as his micromanagement and zealotry) and some not at all his fault (extensive propaganda against him and some bad luck). You could carry out this exercise with most new leaders that get selected, but somehow it is always women that are under the microscope and not men.
From my perspective, I wouldn’t exclude a leader just because they were responsible for an empire’s decline, I'm not even sure why you're discussing about this. When I think of potential leaders for the game, I prefer historically famous and impactful figures — for better or worse. Take Philip II, for example: you mentioned him, but I can think of dozens of leaders in the Civilization series who were responsible for their nation’s downfall, or even for atrocities like genocide or war crimes and yes, as you said, nobody cares

(or at least, the majority of people doesn't care).
Again, it’s all a matter of personal preference, but I definitely would not say that one of the most impactful leader in the spanish history felt "forced" (even if he was impactful for the "wrong" reasons!). Maybe people like you prefer only “positive” figures — which again is totally fine - but that would definitely narrow the range of possible leaders in the game.
This seems like much ado about nothing. So what if now a whopping 36% of civ leaders are female? Are we to take the claim that that's too many female leaders as valid criticism? Or that somehow it becomes too many if specific male leaders are not in the base game (which has been the case in past few iterations of the game)?
I’ve already said I don’t care that much — I only calculated the percentages because it seemed clear there was a pattern, and it felt odd to deny it.