IDK, it depends on the game for me. I can forgive mediocre gameplay if the story is really good.

For example, I got a bit bored with the fighting in Yakuza 0, so once I finished most of the side content, the story kept me engaged. I remember pushing through the last few segments to get to the cutscenes.

But Zelda games aren’t that, I play them for the gameplay, not the story.