I play Conan Exiles which isn't exactly an MMO, but has the same sort of resource gathering grind. While my character is new, I don't actually mind it, but once I'm no longer just surviving, but thriving as a character, the basic resource gathering becomes mind-numbing due to the shear amount of stuff I need. There's no way to automate any of it.

Dunno, RuneScape seems fun? There's lots of types of materials, lots of ways to gather? True, most of the mechanics are just click-and-wait, but it's not like most MMOs where wood isn't any different from ore...

I'd argue that New World made gathering and to a lesser degree crafting a lot of fun. The rest of the game was kinda crap, but I did actually enjoy doing material farms.

FFXIV has a decent gathering approach