I really don't see how it is less effective in an RPG. If anything, I think it more effective as the players are directly interacting with the NPCs via their characters. Now you don't need to frontload all of this in the beginning of the adventure, NPCs affected by the situation can also be met at the location when it makes sense and so forth. But interacting with NPCs via free roleplay is one of the most important things in a RPG and should not be overlooked.
15 or 20 years ago there was a game that I was a player in. My character's family had been captured by the BBEGs and I was tasked with letting them know when we found the witch prophesized to bring them down. If I failed, my family would be killed. They were watching, so if I said anything, my family would be killed. They gave me a magic item to call them with when we found this witch.
We were wandering through a swamp and we came to the cabin of a female spellcaster who we had determined through spells to be evil. I decided to "make a mistake" and summon the BBEGs because we had found the witch. That way they would be revealed, but without me telling the group about them. The problem was that we had found a young(10 or 11 years old) girl as the sole survivor of a caravan massacre and had brough her with us. What we didn't know was that this girl was the one we were looking for.
When the BBEG's arrived through portals to respond to my "mistake," they immediately recognized the girl as the one they were looking for. Having faced them briefly at the beginning when they took my family, I knew they were waaaaaaay outside of our power level and there was nothing we could do to them. We would just end up dying there because we were encountering them directly well before we were supposed to. The DMs(there were two) had no idea I would do that.
They had appeared and grabbed the girl who was close to me when I summoned them. The party told the BBEGs that they would stop them from getting back through the portal with the girl or die trying. Knowing that my family's lives were still on the line, I turned and stood between the BBEGs and the girl and the party and told them that they would have to kill me first. That really took everyone else aback and after some roleplaying they backed down and let the girl be taken away. Once the BBEGs were gone, I explained to the group why I had stood in their way. There was no secret any longer, so I could do so. The group rallied behind me and said that we would track them down and rescue both the girl and my family.
All of that happened without a single die roll. There were consequences, stakes, and a lot of roleplaying. After the game one of the other players said that it was the most intense experience he had ever had playing D&D.