So, I had the same experience with linen sheets. I bought a buttery soft set from coyuchi. Pricey but so comfortable. Had holes within two years.

From my research, anything that is very soft has been “stone-washed’. Which is essentially aging the sheets to make them softer. If you want sheets that will last they need to be untreated. They will also feel like a burlap sack for a while.

I bought a set from morrow soft goods. They are considerably thicker than the coyuchi ones. Have had them about year with no holes. They were not nearly as soft but have worn in well. I like them.