This is a common occurrence for me since I don’t have much time to play. I often get about halfway through and then stop playing for months. When I come back to it I always want to start from the beginning and then the cycle happens again.
One example for me is Fallout 4
NWN 2. I could never complete the game because it would glitch out during the past where you’re building up the castle before going to war.