Ratskinner
Adventurer
It really depends on the specialty priest. The ones in the Complete handbook were pitiful compared to the standard cleric. The standard cleric got major access to most of the spheres, all armor, decent weapons, turn undead, and the 2nd-best THAC0. Aside from tacking on lots of special class abilities, you couldn't really get all that much better.
As with a lot of game elements, 2e wins when it comes to flavor and loses when it comes to effectiveness or balance. I loved the specialty priests, but I thought the 3e designers' criticisms were valid, and I think the 3e cleric was a good compromise between customization and niche/role fulfillment.
IIRC, the 2e Legends and Lore was the first source for a bunch of favorite specialty clerics. (Also a lot of weird ones.) Once the Skills and Powers came out, though, things got out of hand.