Let me complain about faith in more detail:
Buffs and healing are garbage for 3/4th of the game. The early healing you get costs you estus flask charges, so the "benefit" from it is pretty much non-existent or even a net negative.. You get more total healing at the cost of some of that healing being really slow, a tradeoff not worth it in a game with this level of aggression in bosses. In order for your weapon buffs to actually be better than just using resin, you need to be raising your faith constantly, all of which means in the end you will be doing less damage. Also of course, if you make your weapons scale on faith with lightning infusion, then you can't even buff them and your damage is split now. The only buff that is really game-changing is tears of denial.
So what about offense? Lightning spear is garbage, pure and simple. Even at 40 faith, which you aren't going to be able to get before at least midgame, you will be doing way worse damage than simply meleeing. Stake is melee range, which again doesn't do enough damage compared to just melee to matter. Great lightning spear and Sunlight spear aren't available until the end of lothric castle or the final fucking boss. Are you kidding me? The one saving grace of all this is you can just get great chaos fireball and use that instead, as even with just faith raised it ends up being better than lightning spear and stake. Then again, why did you go faith and not just go pyro at that point? Once you do beat the game, gratz, you have Sunlight spear, which feels like it is about as effective as great chaos which you got midgame.