I was poking around in the Goldrush VMF a couple days ago, and I saw those being used a lot.
Since they can be set to fade at a distance (while func_detail can't), much like a prop, I imagine that func_lod brushes are useful for large maps so that a player's computer doesn't need to draw details the player is too far away to see.