A couple interesting resources I've run across on this topic:
https://youtu.be/MUExoqhDr_Ehttps://youtu.be/v1GfBHY1FzIFor my part, after a reddit thread (can't find it...), I most recently bought a set of ralph lauren cotton sheets, 400 thread count and fairly thick/stiff ($45 I think? At TJ Maxx). They're perfectly comfortable and feel just like my old set- which my husband and I used for seven years of weekly washes and only got rid of since we went from a full to queen size bed- it's still in good shape. We use standard cotton most of the year, and flannel in the colder section, probably an 8/4 months split?
We go through flannel a little faster, which isn't surprising since I wash and use a dryer on every week! And flannel gets threadbare and rips eventually. But still, I usually get 3-5 years out of flannel, and I buy cheap sets ($20).
I've slept on some *very* swank bedding, although not linen, and frankly I didn't care for it that much. (Silk, and another time some sort of extra special egyptian cotton?) For everyone saying it makes such a difference- what was your adjustment period? Or did you like it straight away? Not that I ever see myself getting a Mega Swanky bedding set, but my MIL buys insanely pricey gifts for us sometimes.