I never used Caith Sith, because, as you mentioned, I didn't care for his limit break, which is also the same reason I rarely used Vincent. I also never used Aerith except where required, because I didn't care for her character.
My most-used other party members were Cid, Tifa, and Red XIII due to a combination of their innate abilities and limit breaks. Out of the others, I'd more likely use Yuffie over Barret.