Most manual coffee grinders should have quite long lifespans in home use. You have to grind a lot of coffee (or, I guess, one rock) to wear out burrs.

1zpresso currently has probably the best rep at the moment among enthusiasts, but Kinu, Comandante are also well-regarded. All of those brands have some ability to get parts replacements if needed down the line, but which specific parts are available may vary.

A major differentiating factor is whether you need to be able to grind for espresso. Some grinders are optimized for espresso, some for pourover, and some are intended to both. Espresso requires more minute adjustments and the ability to grind finer. Traditional espresso benefits from a higher proportion of fines, contributing to the body of the shot, while pourover, especially more modern/third wave style, may benefit from less fines and higher clarity.

Some popular grinders:

All purpose: 1zpresso K series, Comandante (may need "red clix" upgrade for dialing in espresso)
Filter only, high clarity: 1zpresso ZP6 (currently back in stock at Rogue Wave in Canada, not sure for how long)
Espresso: 1zpresso J-Max, Kinu

The Orphan Espresso Lido OG also seems like a good choice for a BIFL all-rounder do to its robust build, BUT it seems like there's an issue with some of the parts in their adjustment mechanism on the current iteration that they're working on addressing.

A couple of comprehensive roundup videos:

https://youtu.be/JySL64iigT4

https://youtu.be/MV6awoNQXHU

Note: this is just me synthesizing reviews basically, I'm not a grinder expert. (But I have a ZP6 and a J-Max and could answer questions about those.)