Is the
Cipher Pata found in the Roundtable Hold any good? I'm looking into giving a Faith build a shot and a pure Holy weapon with good scaling sounds nice, but I'm not sure how effective it's going to be down the line. I enjoyed Caestus/Vanquisher's Seal runs in DS3 and DS2, so I wonder what this is going to be like.
If you want a pure holy blade, get the Coded Sword, it's much better. Still, keep in mind they're only usable as side arms, not your main weapon, there's many enemies that are deeply resistant to holy in this game (otoh they're really powerful on those that are weak, like undead).
Why the coded sword? because its weapon art is a gigantic arc that staggers in a single hit all the weak foes around you. It's great for exploration. The art is a little slow, but the reach is so big it's not difficult to get it to hit.
For boss fights, the blasphemous blade is arguably the faith build's moonveil. Very, very high damage weapon art, better range than moonveil (and mini AoE so it kills multiple enemies if lined up), solid stagger. If you combine that with Golden Vow, Flame Grant Me Strength and the fire damage boosting talisman, you reach the sort of bullshit damage that dual katanas with bleed do.
Don't underestimate using regular weapons (the ones you can throw ashes of war into and which you can mod the scaling affinity by using whetstone knives) too, they can throw more variety to your moveset when you need like like wanting faster weapons in your arsenal. Bleed is effective even if you don't have a bleed build. Seppuku on two katanas will shred shit no matter what build you're using.
Overall, faith is cool because you can play with many elements which can rip to shred enemies that are weak to them. If you slightly hybridize with arcane, you'll get the cool arcane weapons too, the rot spells (really good damage over time stuff, cast once then sit behind a shield). Experiment, it's powerful stuff.