How Long Before A Game "Overstays Its Welcome"?

[Zippy6]

Depends on the type of game. I have a hard time with fire emblems length. Engage was the last one I played and by 25 hours in I didn't want to continue.

There's no limit for me in terms of hours or weeks, if the game stays fun and doesn't get tired from repetition I'll keep going.