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.