As for what I mean by narrative, much of the appeal of D&D seems to lie in crafting the story and adventure, being a part of the plot

That's what I was after. I know some people play in a much more involved way but when I played so many years ago I love the plot and setting, but really worked the mechanics. It may have been you got a DM or group that was just not suited to you.