Here's a question - is there a point to going Weapon Finesse instead of just pumping STR? I'm currently playing a Rogue/Cleric with low STR and high DEX, but I might reroll/respec the entire way around.
I was doing a cleric of calistria with rapier going for this, since rapiers often have dex to damage trait. I found it not good on clerics. Normally you go dex on damage, which uses up few feats to consolidate your offensive and defensive on both dex so you can go unarmoured or light armoured to take those feats. However it's not worth with clerics because you can take stuff like effortless armour and what not, plus you don't really have enough feats to spare for weapon finesse and the like then get the feats to specialise in dex on top. I was doing pure cleric however and if you only get few levels of cleric and mostly rogue it might be worthwhile.
There is an agile rapier +2 in act 2 shop to go for. In my pure cleric built my character was more of a frontliner/buffer/debuffer and honestly the damage didn't matter much in general. However an inquisitor/rogue or pure inquisitor even might work with this. I didn't do that for aesthetic reasons.
It is worthwhile in this game in particular because you can do monk dips and such to stack your AC up to a level unreachable by armour characters, though there is definitely a feat trade-off because dex AC defensive builds are more feat heavy.
If you want to do a damage dealer cleric/inquisitor, I would say going with medium armour and just some dex to pick up some key feats might actually be better. Cleric damage comes from self-buffs and enemy debuffs (which benefits whole party) and inquisitor is just judgement and weapon enhancement stacking which is better with STR/Armour builds. Inquisitor might be able to do dex melee simply because of free teamwork feats, but I feel it would be lacklustre in damage dealing.