Question: is oath of devotion good?
Answer: Yes, it is very effective in combat. The Sacred Weapon Channel Divinity is roughly equivalent to having advantage on every attack (with +4 or +5 CHA). Turn the Unholy can trivialize encounters with fiends and undead (especially undead swarms). It's spell list isn't staggering, but not bad.