I had fun grinding in Mother 3. Not that you were necessarily required to because it was rather easy. I just wanted the ultimate weapons and gear for everyone. Now why is it fun? Because the battle system is fun and if anything grinding is just a form of practice for getting the BGM rhythms down. So it was a three-fold reward. Higher stats, rare items, and better skill for myself.
Other games, usually not so much.
Other games, usually not so much.