The best ones that have weapon durability IMO are Monster Hunter, where your sharpness degrades over time when you use your sword, and you have to sharpen it again, and Dark souls where, depending on your planning, can become an issue and make the game more interesting, or just be a none factor.
Firstly in Monster Hunter going down to 0 doesn't break your beloved weapon, it just makes it woefully ineffective. Sharpening it, is not about going back to town, and paying some guy to do it. It's about time required to get your weapon back up to full strength in the middle of a pitched battle. It's part of the battle, and so you have plans around what to do when it happens. It can add to the encounters, and is one more thing you have to plan and take into account for.
Dark souls is one of the few other games I would say actually benefits at all from a durability system. A lot of that is because they tell you well beforehand when something is breaking, and before it breaks it get's a catastrophic power loss, making you not even want to continue to use it. This is offset heavily by being able to buy a repair box, and repair stuff at every bone fire, but it's something you can forget about, and have bite you in the ass. My most epic kill of the last boss I had been fighting him for some time, and got him real low, but then my Pike started to break. I didn't have another weapon, and couldn't switch in the middle of fighting Lord Gywn. I had to finish the fight with my busted ass pike and break it off in his skull. And I did, and it was glorious.