That's not how D&D is pitched though. Not by fans nor product creators.
It's "Do you want to play as a character like Jamie Lannister, Hercules, Gandalf, or Lupin?"
not
"Do you want to play a blacksmith, choir singer, or street rat who might live long enough to be a Knight Commander, High Paladin, or Prince of Thieves?"
Not to mention that in 0e, 1e, and 2e, your chance of living long enough to be heroic was low without DM favoritism.
That was the bait (the hero is level 10...) and switch (....You are level 1 and will die 5 times trying to get there.).
So yeah the game shifted to match the pitch. 4e and 5e more or less made you heroically powerful by level 5. And they marketed that you could and would get there.