Other weapons are very specific like Nurylna that is only great for thrower build
I never played thrower build ... bcs throwing is so anoying with removing icons from your bar ...
But Nurylna is actually pretty interesting for Reveberation build too.

It dont give you huge amount of damage, but enemies are basicaly permanently dazed and much more fragile against certain efects.

Shar's spear really sucks
I had the same feeling ... until i just recently noticed that it allows you to cast that darkness every turn for free.
I thought its once per short rest as the rest of weapon abilities ...
So anyway, i would move Shar's Spear from "really sucks" tier to "really depends on your party composition" tier.

What really sucks tho, is Selunite Spear imho.

I really wish the definitive edition will rework most items in the game. I'm sure Larian know we are always using the same 10% of them^^
100% agreed.