Sadly mice aren't really a BIFL item given their frequent use and how switches have a lifespan before wearing out. You can surely get many many years out of one, though!
I've found the Logitech g502 to be my favorite overall mouse, so much so that I bought one to keep at work. The scroll wheel mode on Logi mice is lovely for precision work (clicky) or fast and smooth; a feature I missed greatly when I tried other mice. My first one started dying after 5 years but that was used for regular gaming sessions on the daily.
Don't be afraid of the extra buttons on gaming mice, either. You can always just not use them but I've found the buttons on top incredibly useful as an undo/redo pair and makes working in anything so much nicer.
That being said, the best mouse is the one you find comfortable. Build quality is kinda the same amongst most brands. If you can work with circuits, repair is easy for any mouse. Optical switches and scroll wheels are cool but will need more stringent cleaning (my Corsair M65 had issues regularly because of cat hair somehow sneaking in).