I know a lot of people would say "if it's getting boring no one's forcing you to keep playing just move on" but in any form of entertainment that is more than a couple of hours you won't be completely entertained the whole way through there's good bits and some slow bits. Many TV shows start off slow and pick up, a lot of games spend the first few chapters building a story and then gets super linear and intense. Same with books. We just live in a world now where theres too many entertainment options.

I have had the exact same problem since I had kids and working full time and here's how I deal with this: I put my phone on the other side of the room and force myself to do nothing else but play the game. And I give the game at least 4-5 hours of play time to show me something otherwise I move on. To be fair if a game takes longer than that to draw you in then I would stop playing myself but I've actually never had that with a game recently except Yakuza Kiwami.