Depending on how old you like your old school, you might enjoy Spiderweb Software's games. They (mostly just a guy and his wife) have been cranking out RPGs since 1994. While all their games are superficially similar, there's an impressive amount of narrative and mechanical variety. If you're a D&D fan, especially the Forgotten Realms setting, you might enjoy the Avernum series. You're a prisoner, banished to the underground realm of Avernum , never to see the light of day again. However, you are not alone, as the ruthless Empire which sentenced you has long enjoyed sending its dissidents into the subterranean realm. In fact, there are several factions which vie for influence, and the player can throw their lot in with any or all of them. In some ways, it feels like an old school Underdark module for DnD.

Their other series are worth checking out too. In Avadon, you play a party of inquisitors (essentially) for a tyrannical, immortal overlord who exercises nigh totalitarian control over an alliance of 5 nations. Over the course of the game, your party uncovers a far-flung conspiracy against your boss for his abuses of power, and you are free to RP your characters' reaction to this in a number of ways. Even further afield of that, the Geneforge series is set in a science fantasy world which blends magic with bioengineering and genesplicing. As an apprentice of the Shapers Guild, you have the power to change (or even create whole-cloth) life forms to suit your purposes. Brings created in this way are programmed (for lack of a better word) to be completely obedient to their Shaper, despite otherwise being sentient, free beings. The ethics of this form a large part of the tension in the plot. Mechanically, though, it means that the game is like a weird Ultima/Pokemon hybrid, where your party consists of your mad scientist chimera creations, who will protect your squishy gene wizard until their dying breaths.

I first came across their work when I watched Jeff Vogel's GDC presentation several years ago. It's an hour long, but, if you have the time and interest, it's a very candid look at how the sausage is made in indie game development. In particular, I appreciate that he is very conscious that the games' visuals could at best be described as "quaint", but that just encouraged him to lean into the writing even harder to make up the difference, since that cost almost nothing.