Spores is somewhat borked in PnP, with key abilities competing for your reaction. I expect Larian will make significant changes to deal with this - probably by making the aura always on. Still, I don't think it's strong unless you multiclassed into something that would give you extra attack (hint: 6 levels swords bard).
Tempest, on the other hand, is one of the strongest subclasses for clerics who want to do gratuitous damage, and I see no reason to expect significant changes from PnP.
Between War and Tempest which one you would say is better?
Tempest by a land slide.
War gets you a nice extra attack at early levels and , but its channel isn't as good and it's Domain spells are meh.
Tempest gets you a damaging reaction (that later on can push enemies away) which is huge, it has a nice channel divinity with good compatibility with its really solid Domain spell list.
I've been thinking on making a War Cleric that was too drunk on violence and war that tries now to find redemption. Would that role play work for Tempest Cleric?
Tempest is closer to an evil domain than war is.
War domain is pretty neutral, both good and bad gods have it in their portfolio. You can interpret it both as crazy blood hungry warriors, and as noble champions slaying evil.
Tempest is mostly about the destructive power of nature, and tends to mostly be a domain of evil gods. Some Chaotic good gods still have this domain. But theres a much bigger chance that a tempest cleric would be trying to find redemption as a war cleric than the other way around
