It does vary from game to game, but to be frank, some games just exude an aura of incompetence that you just know won't go away regardless of how long you play it. If there's something wrong with the core mechanics or look/feel of the game, then it's unlikely to get better with more play time.
If it's a story based game then I'd say give it a bit more of a chance than one that sells itself more on the gameplay. I'm more prepared to give up quickly on a sandbox or action game than an RPG for example.
But as others have said, a good game will know how to sink its claws into you from the get go. Either with setting up an intriguing narrative that demands further exploration or having fun and intuitive gameplay from the get go.
If it's a story based game then I'd say give it a bit more of a chance than one that sells itself more on the gameplay. I'm more prepared to give up quickly on a sandbox or action game than an RPG for example.
But as others have said, a good game will know how to sink its claws into you from the get go. Either with setting up an intriguing narrative that demands further exploration or having fun and intuitive gameplay from the get go.