There's of course a simple solution to the issue and it's the reason why FromSoft's implementation of randomized loot is among the best: you don't have to engage in it. There's a billion of other gear you can use. "But muh Halo Syche". Fuck the Halo Syche.
"It's among the best to have to farm a weapon in a poison swamp or wait until you reach end game to get it". Brilliant Lyric, you never fail to post the dumbest shit.
Thorn sorceries scale off faith and arcane. There are 3 staffs that use faith as a modifier and 1 of them is dropped from a unique enemy in volcano manor with 11% drop rate and the other is a specific type of fire monk with a 2% drop rate. The final one is a fixed drop but has vastly higher stat requirements to the point where using a mixed staff is pointless as you would already have the stats to use a normal intelligence based one.
We could question why From thinks putting faith buiilds spells on an item they can't really use and then requiring 3 stats to make them remotely effect is is a good idea. But then we have to question what From actually think is a good idea. Elden ring being as shallow as a puddle has multiple faith types with unique casting weapons to improve the damage. Instead of fleshing these out and giving you unique builds they're more or less the same 3 spells and often the unique equipment clashes with the build.
Lets take a look at a Madness build. Something new and unique to Elden ring so you would expect it to be reasonably fleshed out since it's got it's own ending.
Base game has one weapon that does Madness. Vyke's spear has an E scaling on strength, this is basically as bad as scaling can get.. But wait! The scared seal also scales off Str, Dex, Int and Faith.. So your madness build gets a near useless buff from strength. But your spells require faith and the only decent scaling is off of Faith so why the fuck does the only weapon option in the base game clash with your primary damage stat? But wait the DLC gave us the frenzy perfume bottle so throwing magic dust is... oh that's dex too. Because faith wouldn't make any sense.
Actually I was joking. The vast majority of the game is immune to madness and every boss is. So your awesome new status and magic type is completely worthless compared to using the basic fire magic which is easier to get, uses all of the same buffs but has better spells and can be built around using almost any weapon with the right ashes of war. But hey.. Madness ending right? This is how bad From's design is. They create a specific ending for a build and give it 5 items and 5(6) spells. It has a built in balancing mechanic of self damage if you abuse it and it's seal is hidden behind a NPC quest line and multiple obscure invasions.. But it's just utterly worthless.