Had this article bookmarked to finish reading, finally did it 3 months later. Has some cool recommendations at the bottom of the article!
There's the old-school TTRPG purity of Roadwarden (also great if you fancy essentially playing through an entire fantasy novel); the dense flexibility of Rogue Trader, and the way it delights in just letting you make the worst possible decisions; the rich storytelling of Citizen Sleeper, and its fascinating relationship to its dice mechanics; the wild world-building and enthusiastic skill checks of Skald: Against the Black Priory; and the audacious scope of Caves of Qud, with its potent combo of TTRPG freedom and simulation-heavy world generation