We may be overhyping Radiant Story, but in all fairness Bethesda aren't; and, from a modder's perspective if not a player's, it may deserve some hype.
Todd also had this to say about Radiant Story in an interview with OXM (transcribed, not paraphrased):
OXM: You're using the Radiant Story to add more nuances to the quests, is that right?
Todd: Right, so we have this new piece of tech called Radiant Story, that like the Radiant AI, kind of uses the same paradigm in terms of taking a quest, or any activity, and saying well, we want this to be a specific activity or we're gonna let the game choose. And so it's a really really powerful tool that honestly we're still figuring out how to use, there are some really nice ways that we can use it; where, you know you go into town you run into a character, and the Radiant system can say, oh, you know, I have a quest template that could fit this character, and your character - I'm gonna give you a quest, right now. It's a tiny one; the bigger story based ones, the factions, the main quest, we're still writing by hand, but we're using Radiant Story, the Radiant Story system even to make those quests, even when all the roles and the things are very very specific. It's just- it's how we make quests now.