Whoever compiled these lists seems to have a low bar on “making history”. The only one who is really memorable is Queen Victoria. Monarchies are a different story than democracies, because in a monarchy women can become an inspirational figurehead of a people in a way that’s not really accepted in liberal democracies.
It is usually true that there’s a great woman behind great men. Women are really good at helping out and just doing practical, necessary things like keeping a household in order. They are the glue that holds groups together. However, none of that makes them good leaders.