Are the effects listed in Thaumaturgy, Druidcraft & Prestidigitation meant to be exhaustive?

Trying to justify reason Divine Intervention might fail, help?

Do PCs need to take a long rest before leveling up?