I mean, it's going to be pretty hard to tell a story in DnD that's not fundamentally Heroic. You can't tell the story of Dog Eat Dog in DnD very well. You can't tell the story of Dogs in the Vineyard in DnD very well. You can't tell the story of Don't Rest Your Head, or Monsterhearts, or even Fiasco very well in DnD.