Looking for a game with cool/glowing weapons

(PS5 pro, ps portal and PC player here)

I’ve been trying to find a game that scratches a very specific itch.

I really like games where you can get weapons with noticeable visual effects – glowing blades, fire, lightning, auras, particles etc. New World is probably the best example I can think of. I loved putting gems on weapons and actually seeing the effect on them.

I’d also like the weapon to feel like my weapon, if that makes sense. Something I can upgrade or work towards and keep for a while, instead of finding a cool sword and replacing it with a slightly better one 30 minutes later. And not something I transmorg. That makes every weapon look like something else.

I’m fine with RPGs, action RPGs, JRPGs, MMOs etc, although I’d prefer something that actually has an ending or at least a point where I can feel “done”.

The main things I don’t want are isometric/top-down games like Diablo or PoE, and I’m not really looking for Soulslikes either.
Third person would be ideal since half the point is actually being able to see the weapon I’m using lol.

Any suggestions?