It depends on the game and its franchise, quality, variety, repetitiveness, and personal preference. A Yakuza game or something like The Witcher 3 is fine to me because of the variety oand quality of entertaining side and main quests, you can play an hour or two a day and be constantly seeing new stuff that's fun even if gameplay elements like combat will get repetitive. It helps that I'm into the franchises already because for something like Assassin's Creed, it's really hard for me to want to make that investment, and it's the same for many jrpgs. A good variety of things to see keeps the games from getting stale making it feel like you are almost watching a TV series where your always coming back to see new shit. I didn't really have the patience for Breath of the Wild because the variety in that game was mostly its shrines, which to me just wasn't very interesting because the theme was almost always the same.
Long games have to be like Star Trek to me, filled with a variety of interesting stories and stuff to see so it's worth my investment.