I believe I know that answers to these questions, but thought I'd confirm how others may have ruled on these.
Holy Aura - If an evil creature attacks the warded creature, the attacker is blinded. Does the attacker have to make a save for each successful attack? Or one save per round? I ruled that is was per attack.
Storm of Vengeance - This summons a huge storm cloud. I ruled that this spell needs to be cast outdoors to work. I just couldn't picture it in a typical dungeon with 15ft high ceilings.
Well, in regards to Storm of Vengeance, it seems comparable to Call Lightning and Call Lightning Storm (level 3 and level 5 Druid spells). Both explicitly work indoors and underground. As Storm of Vengeance is a 9th level spell, I'd say it works indoors.
Holy Aura states that when a melee attack is made, they are blinded. This wording leads me to believe that each successful melee attack is another instance of blinding and so another save. It is an 8th level spell, so that seems appropriate to me.