You should let your good memories stay where they are and not read any more of that series. The first two were good, with the first one being actually awesome.You might like The Painted Man (Or The Warded Man depending on your country) by Peter V. Brett. It’s been a long time since I’ve read it but the characters starts out using magical wards and hand to hand fighting demons. I think he eventually moves into weapons but I remember the fighting being very close quarters type stuff. Sorry if my memory is incorrect, but it’s a fun series anyways. I think when I was reading it only two books were out, I just looked it up and they’re all out now so I may pick it back up.
I am fuzzy on the details here so I could be getting specifics wrong, but book 3 has a lot of the various female povs, including the sister of the spear guy (Sheherezade or something), and while I'm completely fine with good female characters, these quickly fall into the intolerable category like so many others over the years (Wheel of Time). On top of that, this book repeats a TON of shit that you already knew from the previous books, but just from a different perspective. That made that shit super boring for me because the new angle added nothing interesting.
And then the book ends in a literal cliffhanger after this big huge fight we've been building up to. As in, someone is hanging off of a cliff, and we have no idea if they will survive (other than that of course they will survive). I said fuck it after that book, and my best friend, the one that introduced me to the series in the first place, agreed and has never read the last ones either.