What is the deal with Terrain Level of Detail (TLOD)?

I searched through the forum about some other discussions about Terrain/Object level of detail and found an interesting quote:

So it seems that lowering a slider (Object level of detail in this case) does not always result in higher performance.