The problem with grinding, is the repetition, like, pokemon games until 4th gen (and black and white) come to mind, where to get every pokemon to the level on the current city gym, you would spend 20 minutes for each pokemon that you have, and that number is normally six. So, 2 hours of grinding, 8 sessions, and 1 more session of grinding before the league. In black/white 2, they put the pokemon breeders to make grinding easy, so in 10 minutes you had the team on the level you needed, and in gen VI they changed the exp. share that if you just go in the game normally you'll have a over level team.
The thing is, most rpgs, and mmorpgs that require some form of grinding, make it boring, people praise world of warcraft, but man, that game is boring. Go there, kill 5 things and get 3 things of that other thing, and some games reach the: get 50 items, that item have a 10% drop change, on a monster that take 3 minutes to respawn, and the area have only 10 ~15 monsters at the same time.
I'm not against grinding, but the way people make grinding happen, if you get levels naturally by exploring, and the combat is fun (something that turn based games are not if you have to do the same battle over and over again), one game that made grinding fun for me, it was elder scrolls online (i played the beta before release only), and that game, you would gain level by doing diverse quests, and exploring finding some stone things that would give you a level, Pokemon Black/white 2 are my favorite pokemons (i never played gen VI) because i don't have to grind that much because of the pokemon breeders (and because the battles feel good, the story is one of the best in terms of pokemon, the rival is cool, the champion is cool and i love the music in this game). Skyrim is another game that i like a lot, because i grind what i need to grind, and there are a lot of exploits (and grinding exploits are the best. The witcher 2, i'm trying to finish this game, but it is so boring, and the level system looks shallow already, and i'm in the beginning for what i can see. In Diablo 3, you get levels by putting the game on a harder difficulty and just exploring too.