Maybe I missed it, did anyone mention the Paragaans on Enterprise? That always sticks in my mind -- "oh, we're about to see some matriarchal aliens on Star Trek for the first time in forever!" And no sooner than that thought entered my head, they were suddenly all incinerated off-screen!
Personally the one I'm dying to see is whatever Vilix'Pran was.
Well, there was a matriarchy on DS9 but they all had pustules on their faces. What the hell what that about?
The thing I find a bit offensive in Star Trek is that the only matriarchies that we've seen all have glaring flaws, Like the males are some diminished imbeciles. As if the only way that the women could ever be in charge is if there is something very wrong with the males. If you see what I mean.