As mentioned, the Mystery Dungeon games do this but with more complexity and depth. I'll add Etrian Mystery Dungeon to that list as well. Ultra niche games though, you've very much got to be a dedicated grind enjoyer to work your way through one. Even Pokemon Mystery Dungeon got rather grindy quite quickly.

Personally, as far as FFXIV's implementation goes, I just found there wasn't enough variety in the pieces for me to get interested in it. It always felt like the same limited stuff sprinkled out in a different pattern.