I used a G700S for nearly ten years, only got rid of it because a decade of human use caused it to get pretty gunked up. I never had a mechanical failure in that whole period.
Before that was a Deathadder, also button failure. The only mouse I've replaced for any other reason was a Corsair M60 which had its cord chewed off by a friend's rabbit. We soldered it back together but it didn't last.
Now on a Razer Basilisk Ultimate which uses some sort of optical click detection, we'll see if that's actually more durable or not. There's still a physical mechanism to produce the clickiness but I don't know if that part is failure prone like the mechanical buttons have been.