When he enters the market, he's going to be 29 years old. And he's clearly a guy who has already made the best of his potential -- nobody's paying a premium hoping to unlock anything extra. The question then becomes what his production is likely to be worth.
He's coming off a stretch of 4.3, 4.5, 3.9, and 4.8 win seasons. To make the math easy, let's say teams think he's a 4.0 win player going into the 2027 season. He's approaching the age where production declines, and the typical rule of thumb is to subtract about 0.5 fWAR per season. So we'd expect his production to look something like this [albeit probably not this consistent].
2027 - 4.0
2028 - 3.5
2029 - 3.0
2030 - 2.5
2031 - 2.0
2032 - 1.5
2033 - 1.0
2034 - 0.5
2035 - replacement level
I'm not sure what the current $/fWAR figure is. But for math's sake, let's call it $10 mil per fWAR. He's producing 20 fWAR in that time. So in theory at least, you could be okay signing him through 2035 for a total of $200 mil.
All of that is full of caveats, though. Much of Hoerner's value comes from two things that public data is a bit behind the curve on. First is his defense. We're usually the publicly available datasets that say he's awesome, and he passes the eye test. But teams have proprietary tracking data (ball, player, weather, etc...) which gives them a better picture of what his precise defensive value is. There could be a gap. Potentially even a large one.
The other place from which Hoerner extracts a fair amount of his value is the positional adjustment. 2B is a tough position, and fWAR gives him extra credit for playing a tough position on the defensive spectrum. But there's been a lot of noise lately that the positional adjustments being used in these calculations are based on pretty old data, and that it's probably time to adjust the adjustments, so to speak. The expectation is that the gap between tough positions and easy positions has shrunk, and the adjustment is too high. Again, I am sure that teams are using their own proprietary formulae for this sort of thing -- so they may value him a bit less due to that.
All that said -- that's about what Hoerner should be paid. Not about what he will be paid. He's the classic type of guy that causes a disconnect between people who write the checks and those who look at the stats. An average hitter without much power whose sole claim to superstardom is a slick glove at a position other than SS or CF. Teams will be worried that one leg/back injury is going to tank his defense and he doesn't have other standout skills to fall back on. So I anticipate him getting paid significantly less than what he's probably worth. And whoever gets him will likely be happy with the outcome.
All that to say, I'd guess if he keeps up the production during his walk year he's probably looking at something like 5-6 years and maybe $100 million or $125 million.