It's older, but The Longest Journey is good. Unfortunately, the final game in the series kinda sucks.
While it's an ensemble, most people would agree that the main character of Final Fantasy VI is a woman—they just might disagree about which woman is the lead.
I also liked the first Xenosaga game, but again, it's a series that goes pretty badly downhill.
I'm pretty sure this article is a really bad attempt at satire. Or if there is a point, maybe it's that... the fact that there have been things in the past that are not just fads (like SQL), that means that current things that are fads (like blockchain) are in fact not just fads?