I've been digging through for all the good spells for an Archivist, but my character is a Tainted Sorcerer so he gets to ignore material components. Favorable Sacrifice and similar spells end up on my list for that reason. But here's the list of spells I'm trying to get off the Cleric list at least:
Resize (Clr 0), Extract Drug (Clr 1), Holy Defense (Clr 1, Pal 1), Sign (Clr 1), Traveler's Shoes (Clr 1), Witness of the True (Clr 1), Desecrate (Clr 2), Elation (Clr 2), Enhance Weapons (Clr 2, Pal 2), Fertility (Clr 2), Guidance of the Avatar (Cleric 2), Lore of the Gods (Clr 2), Obscuring Snow (Clr 2 , Dru 2), Zone of Truth (Clr 2, Pal 2), Adoration of the Frightful (Clr 3), Augment Object (Clr 3), Continual Flame (Adept or Cleric 3), Favorable Sacrifice (Clr 3), Invisibility Purge (Cleric 3), Mass Resist Energy (Clr 3, Dru 3), Skull Watch (Clr 3), Stone Shape (Clr 3), Stonesight (Clr 3), Rockburst (Clr 3, Spirit Shaman 2), Soul of Shadow (Blackguard 2, Clr 3), Vision of the Omniscient Eye (Clr 3, Dru 3), Animate Undead Legion (Clr 4), Black Binding (Clr 4), Enhance Armors (Clr 4), Favor of Ilmater (Clr 4, Pal 4), Feed the Many (Clr 4), Freedom of Movement (Healer 4, Cleric 4, Drd 4, Rng 4), Glowing Orb (Clr 4), Identify Transgressor (Clr 4), Plague Cloud (Clr 4), Revenance (Clr 4), Skull of Secrets (Clr 4), Stone Metamorphosis (Clr 4, Dru 4), Wall of Salt (Clr 4), Ensnare the Heart (Clr 5), Extract Gift (Clr 5), Hallow (Cleric or Druid 5), Haunt Shift (Cleric 5), Hibernate (Clr 5), Mark of Justice (Clr 5), Mule's Enlightenment (Clr 5), Parboil (Clr 5), Past-Seeing (Clr 5), Righteous Wrath of the Faithful (Cleric 5), Rivivify (Healer 5, Cleric 5), Soul Anchor (Clr 5), Stalwart Pact (Clr 5), Banishment (Clr 6), Call Faithful Servants (Clr 6), Cloak of Hate (Clr 6), Create Bad-Corpse Dust (Clr 6), Create Undead (Clr 6), Forbiddance (Clr 6), Gambler's Luck (Clr 6), Greater Dispel Magic (Clr 6), Harm (Clr 6), Heal (Clr 6), Hero's Feast (Clr 6), Revive Outsider (Cleric 6), Wall of Tentacles (Clr 6), Planar Bubble (Clr 7), Refuge (Clr 7), Renewal Pact (Clr 7), Stone Trap (Clr 7)
Note that I already have some of the good ones (Black Sand, Animate Dead, Plane Shift, and Consumptive Field).
JaronK