Depends highly on the game.
Monster Hunter is the best game where I can enjoy the grind. The combat is so great that it doesn't matter THAT much that I'm not getting that 1% drop.
I also don't hate it in dragon quest. Its kinda comfy, probably because of how simple the battle system is.