Definitely one of the great Nikons, but I can honestly say after owning a D4 and D500 and now the Fuji X-T3 the Fuji blows both into the weeds, the Fuji simply does all I need and at lightspeed, its not a better camera, it just does everything I want but better.
If it were to be used just for Macro then a D500 is a bit overkill imho. A D7500/2700/7100 would give very similar image quality, with a little more resolution. You could even go to the D3*** and D5*** with the same (or very similar) 24Mp sensor. If you don't need the other features that the different cameras give you could save a lot of money.
For me, who does a bit of everything, the D500 is the best overall crop sensor DSLR, and could potentially be the best forever as it is unlikely to be surpassed because of the transition to mirrorless by either Canon or Nikon if the rumours of no 7DIII or D500 replacements become reality.