Really cool and cinematic...
for some people.
For me, I very much prefer signature weapons that the user develops a bond with, and then grow its abilities through effort, or magic, or augmentation, or training, or exposure to dangerous things, or...etc.
Having my weapon break all the time gets extremely tedious. It's the game telling me "no, your fun is bad and wrong and stupid, you don't get to have that fun anymore, you have to find other fun, which you probably won't find for several weeks
at best". It's one of the reasons why, despite video game designers
constantly trying to shoehorn in "durability" mechanics, video game
players almost always remove that s#!t whenever they can. Because it's
tedious and annoying, for a lot of people.
It is--trivially obviously--not tedious and annoying for a different set of people. That might make it worthwhile to explore as an opt-in mechanic for gamers looking for that kind of experience. If it were done so, it should get just as much playtesting as any other major mechanic, so that it should reliably work well in the majority of situations that groups come across.
But making it something everyone has to deal with, all the time? Yeah, that's what leads to what
@GreyLord just said.