I've been playing a lot of Ironsworn, and one thing I like about it is that "failed" rolls make the world more interesting. For example, if you fail a Gather Information roll, you do learn information... just information that makes your quest more difficult! Let's say you're asking around the village about this mysterious warlord Ivor the Gray. If you roll well, you will learn something helpful in your quest to defeat him- like maybe he's deathly afraid of horses. But if you roll poorly, you still learn something. It's just something that is bad for you. Maybe Ivor the Gray has a pet giant that he lets smash his enemies? Or maybe he's wielding a legendary sword that kills with one touch.
Now Ironsworn is designed entirely around not planning out the adventures, and just playing to find out more about the world. But I'm thinking of doing something similar in my D&D games.
When a character rolls an Ability Check to find out if they know something, be it Arcana, History, Nature, Religion, whatever, and they roll well, I'm going to try to give them information that's really helpful. Maybe I'll even have the players brainstorm what it could be, and take their best idea.
But if they roll poorly, I'm not going to just say "You don't know anything." I'm going to give them information that makes the world a little more dangerous... even if I have to change the world to make it so!
To do this effectively, I'll probably borrow from the Ironsworn Oracle, which is basically a bunch of random tables. They have two tables for Actions and Themes that give results with wide interpretations, like "Transform Idea" or "Persevere Ally" or "Challenge War." If the characters roll high, I can use the table to figure out something in their favor ("You find out that Ivor is only going to war because he received a vision from his god, challenging him to take on the most difficult battles he can find."), and if they roll low I can use the table to figure out something that makes their quest more difficult ("You find out that not only is Ivor a skilled warlord, but your settlement is only the latest of a dozen felled towns in his bloody path. He seems unstoppable.")
I know this goes somewhat against D&D's style of "the players uncover realities about the world already set by the DM," but I think it could also be a lot of fun!