Part of it depends how many other LODs you will have. If you have LOD_100, LOD_90, LOD_70, LOD_50, LOD_25, and LOD_10, then you can probably go fairly rich on LOD_100. That's because your LOD_100 will rarely come into view.
IMHO, I would suggest that if LOD_100 has 10,000+ polys, then perhaps LOD_90 will have only 5,000 (by trimming out detail), LOD_70 2,000, LOD_50 1,000, LOD_25 500, and LOD_10 100 or something like that. If you're doing something big like a battleship or aircraft carrier then you might go nuts with the LOD_100 and perhaps let the LOD_90 and LOD_70 go a bit higher ... but ... the other limits should be observed.
It is critical to keep the lower LODs lean (50, 25, 10) because beyond a few hundred yards these are the only ones that the game uses. Partly, it depends on computer graphic settings but I found that the higher LODs only came into play when very close to the target. What's more, the amount of detail visible at those lower LODs renders the object as little more than a basic silhouette ... so you don't really need much detail.
Needless to say, it is CRITICAL that modelers make use of LODs to keep the game running efficiently. So go ahead and have fun with your LOD_100 if that is your thing. It will make for great screenshots and get you lots of oohs and aahs for other boat-niks. Efficient use of the other LODs will earn you the eternal gratitude of the rest of us.