The most recent one I had was with Tales of Vesperia - Definitive Edition, namely the Bunny Guild Achievement. The achievement sounds grindy, but decent at first: Have 4 specific characters wear bunny ear accessories for 5 hours straight, which is still feasible when you consider that the game is a 100+ hour game. Where the problem occurs is how you get the items: An NPC gives them to you based off of how many titles you've earned (which you basically get by doing everything else in the game). In the original, you needed about 75% of all the titles, but in the remaster, you need all but one (which you can't get until you get that last bunny ears). This means that when you get that last item, you're 99.99% done with the game. There's nothing left to do, as you've cleared the bonus dungeons, beat the secret bosses, completed all the minigames, maxed out your skills and levels and so on. So, the only thing to really do is to just let the game run idle for 5 hours. Certainly a way to end the completion with a whimper instead of a bang.
As for other, more recent games, I really question the Balan Wonderworld Team's idea to remove most of the game's plot and story from the game itself, and instead putting it into a tie-in novelization.