Well, Dark Sun elemental clerics only have minor access to the healing sphere (spells of 1st-3rd level). I'm pretty sure the CPHB had several specialty priests with minor or no access to the Healing Sphere as well. Not that I've ever seen one of those CPHB priests played...

I'm actually playing a Cleric of Air in a Dark Sun campaign. For a definition of "playing" that roughly means "one session every 6-8 months".