“Heroes of Might and Magic V: Tribes of the East”

Or maybe it's not appealing because no one knows what a "serious" matriarchy looks like, since it hasn't existed in human history?

Actually, matriarchy did exist in human history. Among the Scythians, Sarmatians, and Cimmerians, who later became, among other things, Slavs! So, we have a fear of women in our blood :D

It's just that the artists who drew these elven mistresses decided to embody their erotic fantasies in the game. And they used their favorite thematic pictures of girls from BDSM resources as a model ;)