Regarding subclass comparison, as it's own thing:

Spore druid is the "Forget about wildshape. I don't care about being an animal, I just want to cast druid spells as a caster character. I'll being in humanoid form at all times, so please give me something else to do with my wildshape charges so they aren't a waste." subclass.
And so it does. Spore druids aren't really meant to use animal forms in the first place, so talking about how effective they are is a bit of a moot point. If you're an animal as a spore, you're doing something wrong. Change subclasses if you're gonna do that.

Moon druid is the "Screw spells. I don't care about being a caster, I just want to be a beast. I'm going to be in animal form at all times, so please give me something else to do with those spell slots so they aren't a waste." subclass.
And so it does. Moonies can use spell slots to heal themselves in beast form so players don't feel like part of their build is being wasted by never being in human form. Not to mention the healing actually keeping them in the animal form instead of getting reverted by enemies. If you're in humanoid form casting spells as a moonie, you're doing something wrong. Change subclasses if you're gonna do that. And appreciate having less competition in your party for the best items I suppose.

I honestly don't remember what Circle of Land gets to differentiate them from other subclasses, but presumably they're the hybrid subclass for actually using both your spells and your wildshape.
So if you intend to use both druid features, to do things with spells before wildshaping, use either at different times, or charge in in animal form until knocked out of it and be a caster after, go land druid. The other subclasses are for picking one of the two, not doing both.