I have experience with Dell and Apple keyboards on Linux, and they don't suffer from this issue. The problem is not terrible, but requires a special udev rule to exclude them from powersaving, which is annoying.
What I understood is, the switches on these mice (I have G700) are practically abuse-proof. However, they don’t like to be used lightly and start to glitch possibly from fine dust. Using the switches more aggressively cleans them up.
My first generation G700 still works great.
I’m about to open my second bottle. My first bottle is from the 1990’s.
But that's only me, of course.
Maybe for some of the newer mice it’s an easier ordeal, though.
So, just turn off the mouse and blow in it a few times. It will work normally for a few days after that.
I found this solution on approximately the 12th page of a Google search ~9 years ago. Every other solution was wrong.
I found replacement switches for $10 on amazon, pre-wired with little plug, easy enough to install with just a micro-screwdriver, no soldering. This problem is common enough that there is a good selection of different switch brands/types available. Fantastic. Not disappointed at all anymore, honestly.
I removed a switch from the Pi 400 desktop kit mouse I had laying around and replaced it with that.
Upgraded the slider pads while I had everything apart. These actually made more of a difference than I anticipated.
Virtually brand new, although amuses me that left and right click sound different now.