I answered this for a member of my gaming group a few months ago. I only listed up to 4th level because at the time we had 6th level characters. Some of the spells are from OGL sources and the Sanctified spells are from the Book of Exalted Deeds.
...
Below is a list of divine spells that I find useful.
First I should mention Sanctified Spells from The Book of Exalted Deeds. As a cleric, you don't even have to pray for these spells, you can spontaneously cast them. For example, if you have Resist Energy in a 2nd level slot, but you need a combat spell to damage that pesky evil monster, you can spontaneously turn that Resist Energy, into say an Ayailla's Radiant Burst.
I encourage you to look through the Exalted Deeds Sanctified and cleric spells for yourself. Some seem low powered, but have the benefit of not harming your team mates, or they have weird spell components like Abstaining from sex/drinking/something else for a period of time before casting them or more directly temporarily lowering your Strength.
Now for a list of more conventional spells.
BoHM Armor Contigency - good spell so sleeping cleric can quickly don heavy armor
BoEM1 Guilt - good replacement for Command
PHB Death Watch - casting this spell helps you keep track of friends health, though it is now an EVIL spell
PHB Divine Favor - good spell to increase personal prowess in combat
PHB Protection from Evil or Magic Circle Against Evil - Protection from Evil and its sister spells rock because while in effect they keep you from doing a Shandre and frying whores.
PHB Silence - obviously a good counter mage spell, but presents problems for any other spell caster in the area
BoHM Crystal of Reflection - wish we had this against the beholders, it deflects ray attacks
PHB Any of the 2nd level animal spells, i.e. Bull's Strength
PHB Align Weapon - this spell was made necessary when they changed the damage reduction rules
PHB Remove Paralysis - this and any spell like Remove disease, curse etc. are good candidates for scrolls.
PHB Resist Energy - keeps you safe from energy damage
PHB Dispel Magic - good for stripping away other spells
PHB Protection from Energy - keeps you safe from massive energy damage
PHB Death Ward - this spell is an absolute must, making you immune to HARM and FINGER OF DEATH, plus energy draining undead.
PHB Freedom of Movement - another good spell since it helps you avoid being grappled, which can be bad news for casters.
These are just up to 4th level.
BoEM1 is Book of Eldritch Might # 1, BoHM is Book of Hallowed Might, PHB is Players Handbook.
