I just want to elaborate on this a little bit.I was thinking in terms of what makes sense for the character as seen from a third person perspective. If you were watching a movie does it make sense for the character to do this? I submit that if you’re chasing story the action has to make sense.
The only time characters in fiction do things that "don't make sense" is (i) if the fiction is poorly written, or (ii) the fiction is deliberately absurd.
One feature of well-written fiction is that it communicates its context and presuppositions, and brings the audience along with it. An example I was thinking of yesterday evening (I can't recall why - maybe I was imagining myself being adventurous?) is from the early Tintin book King Ottokar's Sceptre. On p 52 of my copy, Tintin is running down a rocky, switch-back-y, mountain path, in pursuit of a villain who is about 5 metres below him. Tintin leaps off the path, over the edge, and lands on the villain, who is knocked unconscious as his head lands on a rock - while Tintin picks himself up and calmly reads a letter taken from the villain's wallet.
At the top of p 53 Snowy comments on Tintin's feat - "One day you'll break your neck with all these acrobatics!" - but Tintin doesn't, in this or future episodes.
Does what Tintin does "make sense" for the character? I've never felt that it spoils the story, or makes it absurd. The mode of communication - comic-book illustration - helps to convey it as plausible rather than outlandish.
Similarly, in D&D it is not absurd for a player to have their character choose to engage in melee with a creature like a giant or a dragon. Because the way the fiction is set up, and framed, and conveyed (including via the combat rules) all presents this as a plausible thing to do.
But that doesn't tell us anything about whether game play is "chasing a story" or "beating the dungeon" or whatever else the play of D&D might aim at.
And if the table can't agree on the shared fiction - for instance, one participant thinks that the PC trying to confront a dragon is obviously folly, and should just result in the PC being crushed to a pulp by the terrible beast - then there is a basic problem of "social contract": the participants can't agree on a method for collectively establishing, and generating over the course of play, a shared fiction.