It's funny - I really like some systems that give players a lot of narrative control, like Blades in the Dark, but when I'm playing D&D I much prefer to know that I am playing my character, not any part of the wider world.
I remember a discussion in another thread, ages ago, about running investigation-based adventures, in which the scenario under discussion was the PCs searching a house for a hidden document. One suggestion was that if a player rolled particularly high on their Investigation check when examining a particular location, such as a desk or cupboard, the DM should narrate that this was where the document was. I hated that concept. If I as the player was taking my character through searching the house, I didn't want my success or failure dictated by my die roll re-shaping the reality of that situation - I wanted to know that, if I did find the document, it was through my deduction based upon my knowledge of the suspect and of what would make a good hiding place, not just because I got a lucky roll, and if that meant I came up empty in the search, that's just the way it goes.
I've softened on that a little these days, but I still do prefer my character's interactions with the world to be framed in terms of their own capabilities, at least when I'm playing D&D.