First you have to know which stylus profile, then you can search for the manual to find out a life span of the stylus. Some of them must be replaced after 300-500 hrs, some more expensive can be replaced after 1500 or even 2000 hrs. You can count an average listening session at home, so you can imagine how long you can use a cartridge if it’s lightly used demo or hardly used cartridge.
With a macro lens you can see the diamond, but you can’t understand anything about hrs of use anyway. All you can see is that the diamond is sharp and not damaged. If you want to know more you can send a cartridge for inspection under microscope (to professionals), it will cost about $60
Personally i'd like to compare any unknown sample to my own sample. It's easy if it's the same cartridge, but the one i bought NOS (and when i'm the first owner). Comparing one sample to another will tell you more about quality of the used one. If the sound is not at good as another sample then the stylus is worn.
With a macro lens you can see the diamond, but you can’t understand anything about hrs of use anyway. All you can see is that the diamond is sharp and not damaged. If you want to know more you can send a cartridge for inspection under microscope (to professionals), it will cost about $60
Personally i'd like to compare any unknown sample to my own sample. It's easy if it's the same cartridge, but the one i bought NOS (and when i'm the first owner). Comparing one sample to another will tell you more about quality of the used one. If the sound is not at good as another sample then the stylus is worn.