This may just be old man nostalgia talking, but at least part of that spark feels like its gone because the genre became too popular and information flowed too freely.
One of the things I distinctly remember about older MMOs, especially Pre-WoW ones, is how so much information was basically just passed on from player to player. You'd join a guild, because the guild forums are where you could post maps and strategies and the like. But your guild forums were also mostly just private to you, so useful stuff could take a long time to leak out.
With the rise of wikis and big, well connected social communities, a lot of the exploration element of the games is just theme park rides and the mechanical experimentation gets analyzed to death in the first few days because of how collaborative everyone is instead of everyone being stuck in smaller groups with non-perfect info.
Had been eyeballing it for a awhile already. Just needed a little bit of a push to make the jump and start actually taking the time to grok the concept.
I've done social community migrations probably 2 or 3 times though already (Usenet -> Forums -> Social Media), so this all feels pretty old hat to me. Unlike previous Reddit revolts, Lemmy strikes me as an actually useable alternative, especially since other Fediverse communities can help pad out content while the site still tries to build out its own legs and specializations.