Now, all this aside, what you seem to be describing - a campaign where the DM creates the setting, plonks down some potential conflict points and then sits back and lets the players take the driver's wheel - sounds an awful lot like an MMO to me. How is that not simply World of Warcraft or Eve Online? A game with no plot, no story except what the players choose to do.
There are (at least) two different approaches to this type of campaign that avoid it ending up like an MMO. The first was already mentioned upthread: the PCs comes with their own built-in motivations that will give them purpose and direction, either throughout the campaign or simply long enough to encounter the existing conflict points and getting the ball rolling.
The second is saturation: the "potential conflict points" aren't scattered and a chore to find, they're
everywhere, and avoiding them all would require active effort. (And if the PCs are trying to avoid all conflict that's either a fail state or, in niche cases, counts as bringing their own motivation.) And as long as few of the conflict points exist in isolation, the PCs engaging with even a handful of them creates a self-sustaining cycle of conflict.
Sure, the
original conflict points were created by the DM, but the players got to choose which to engage with, and their choices determine, shape, and drive the subsequent conflict points. The resulting story is literally about "what the players choose to do", while simultaneously being rich in traditional story elements, despite lacking an advance DM-written plot.
(Unlike in an MMO, the density of conflict this approach requires is possible because the DM can generate and/or flesh out the speciffic conflicts the PCs decide to engage with and the follow-on conflicts, rather than having to program it all in in advance.)
I believe that being a good story teller is one of the biggest skills a DM should cultivate. I'm not there to wander aimlessly from place to place trying to drum up something of interest. I want you to have a strong story in mind and drive the action of the campaign. I have no problems with that. Mostly because my experience with DM's who want to let the player's drive results in campaigns that stutter to a halt as no one can figure out what to do. The dreaded "rowboat" campaign where you'Re in the middle of an ocean and every direction is equal because there's nothing really going on.
Being a good storyteller is still vitally important in games using either of the techniques I described above. In particular, ideally those points of conflict the DM is dropping into the setting are
interesting, and designed in such a way that they'd be fun elements if included in a range of potential stories, whether they're engaged with by the PCs or not. For example, it takes good storytelling skills to craft a regional villain who would be a fun antagonist if opposed, a good rival/foil if tolerated, a complex ally if coopted, a memorable encounter if interacted with, and an enriching lore/setting element if never met.
And because this style of game requires a ton of improvisation, it helps to have sufficient storytelling skills to be able to do all that on the fly. Ideally one fills in the necessary immediate detail to respond to what the players are doing now, while leaving interestingly shaped voids to return to later if future player decisions make the new content play a different role in the emergent story than originally anticipated. (This usually comes up when players unexpectedly ask for background information about a setting element--you want to be able to create the relevant detail from a lore perspective while leaving interesting gaps that can be filled in if/when the party decides to further engage with that element.)
I have no interest in driving your campaign. It's your campaign. I'd much prefer the DM have a strong vision for what the game is going to be about and not have to spend hour after hour (which can happen) of players faffing about trying to figure out something to do. There's a reason I don't play MMO's. I find them boring and tedious. Get me to the action. Get me to the drama. I'll provide the script after we get there, don't you worry. But, it's up to the DM to get the ball rolling and keep that ball rolling.
So it sounds like you prefer to make tactical choices about how to accomplish your character's goals rather than strategic choices among your character's competing priorities. Cool! The types of games you prefer are well-suited to that. For players who prefer a mix, or outright prefer the strategic side, a DM-driven story where it's their job to get the characters to the action isn't going to be able to provide what they're looking for, since it (almost by definition) can't be open-ended enough.
Earlier, a mystery was mentioned. Well, think about that for a second. Most of the time, the DM is going to know who did what to whom and where. They have the answer to the mystery and it's up to the players to reveal it. From an adventure design standpoint, there's not a whole lot of freedom to choose here. You're either right or you're wrong. Follow the clues, find the killer, catch the killer.
In my personal opinion, the best mysteries in RPGs don't end with figuring out "who"... they're instead just getting started! Longer-term, the more interesting questions are "why" and sometimes "how" and, ultimately, "even once you get those answers, what are you going to do about it?"
As an example, consider a murder mystery where the identity of the killer isn't hard to determine with the party's resources, but (1) the question about whether it was murder or self-defense doesn't have an objective answer, (2) there are competing jurisdictional claims complicating the definition of "justice", and (3) any decisions made regarding whether or how to accuse, expose, capture, or kill the perpetrator would carry political costs.
Edit: See
@EzekielRaiden's post above for a much better and more specific example.
You can't have an emergent mystery story. Well, actually there are systems where you can, but, in D&D? No. You can't. The DM knows whodunnit before the first player sits down.
I disagree. In my example mystery above, it's easy (and arguably inevitable!) to have an emergent story that arises from the decisions of the players even though the DM knows all the factual answers beforehand.