So I finally want to give Pillars a 2nd shot, I did not finish it when I played it the first time.
The only thing I disliked and what kinda ruined it for me is the equipment design.
Armor and weapons dont feel unique for me, because of the way they are set up as just crafted normal pieces.
So I want to know if there is any mods out there that change the equipment to a more Baldurs Gate type of style where unique weapons have special abilities e.g.?

Equipment design is actually kind of awesome, but for entirely different reasons - have you noticed that the least powerful weapon of just about any class in the game is just 50% weaker than the most powerful when it comes to base damage? In other words, that piece of steel won't swing all that harder than the other piece of steel, it's the unique effects that matter. I really like that progression doesn't come from sharp swords which would for some reason cut flesh 500% more than the other sharp sword - instead, you should look for weapons which work well with your playstyle.

As for unique effects that can't just be enchanted, those are in the game and some of them really interesting - but they're few and far between. Keep in mind that not every item with unique description actually is all that unique, and keep in mind that for Pillars, Obsidian tried going with a lot more grounded and so to say 'realistic' approach than with Baldur's Gate. That being said, their story describes very interesting ways to manipulate souls from which some neat unique weapon effects could have arisen - sadly, they didn't use their story to this end, so that didn't happen :-/ Let's hope the DLC fixes that.

And as for mods, there aren't really any big mods for Pillars of Eternity, as it doesn't really support extensive modding, so I highly doubt you'd find such a mod. Feel free to take a look at Pillars of Eternity Nexus tho, perhaps you'll see something I didn't there.

That's one of the things that makes equipment design bad, IMO. I like weapon progression. Skills and enemy difficulty should just be calculated with that in mind. Weapon irrelevancy makes more sense in the context of an action game, not in a level based RPG. I also agree with OP that the weapons were not memorable/unique. Can't remember any weapon in Pillars standing out. But I still remember Varscona (sp?) from the mercenary in BG1, or Celestial Fury and Crom Faeyer in BG2. Just my two cents.

Eh, the game still has weapon progression, it's just not as massive. If there's something that always angered me about RPGs, it was the fact that some bits of steel are infinitely more powerful than others - it made no sense, never felt particularily immersive to me, on the contrary actually. It's always skill of the one weilding the weapon which should matter, not quality of the weapon itself. However, weapon progression is still there, and gameplay wise, it matters very little how big of a gap is between weakest and most powerful weapon - you said it yourself, when the gap is wider, it either means weaker player characters or more powerful mosnters, so it matters very little anyway.

The reason why Pillars doesn't have particularily impressive uniques lies somewhere else entirely - unique weapons do not have particularily interesting unique effects, outside of damage. Which is a shame. There's one interesting unique piece of armor with thorns-ish ability and a ring which adds you spell slots, those seemed to be the most interesting unique attributes of the entire game - and they're not actually particularily interesting when compared to other RPGs. Shame. We'll see what does Obsidian do with soul-bound weapons of the DLC.

While we're talking about the player character progression too, I would have liked that to be more dramatic. I just didn't feel much more powerful by the end of PoE than I did at the beginning. Two levels are being added in White March. Two. I mean, come on.

I agree with you about varying magic on the weapons. I think I do remember that thorn armor, now that you mention it. I would not have so much of a problem with the small range of weapon progression if there were unique weapons and weapon graphics that held meaningful abilities to choose from.