One I do recall is the 2E Complete Priest's Handbook. There was just... nothing interesting, nothing useful. There was no reason anyone would ever play a priest from that book instead of a cleric or druid,.
Back during 2e, if you were playing with my group or with one of several other DMs I knew, you would have been using it (sort of) if you wanted to play a "cleric"or "druid". Not that you as a player would have been using the book to design your priesthood for a deity. The Complete Priest's Handbook was used by we DMs to build the priests of various deities in our campaigns (with a little modification when necessary).
Even today, as a DM, I will take that book over the 5e cleric, 1/2 the 5e PHB subclasses or any subclass in Xanathar's Guide or Sword Coast.