Also, I'd like to posit that Holy Sites give some kind of sanctuary to mortals. That makes them important in both the maintaining and the capturing.

ed: Sanctuary specifically from gods. Again, creative destructive gods would be better off creating a mortal army or something similar (giant beast, hero, plague) to capture a mortal stronghold than just deitying their way in.

Though there should still be room for god duels.