At some level all collecting is a "waste" of time and effort. The joy of collecting is in the hunt, not the meal.
We collect because collecting is a hobby - it passes the time and provides enjoyment. 99% of collections have 0 intrinsic value. (Jay Leno's Garage aside.)
I collect Sci Fi books pre 1970. Their objective value is close to zero. Their literary value is zero. When I go they'll go to the recycling. That's fine. It was my hobby, not my sins.
Inheriting collections is not collecting. It's just stuff yo get rid of.
If there's anything valuable in your collection, sell it yourself before you die. Or put it in the "specials case". No one will sift your collection for wheat - it'll just all be thrown out or given away. Indeed that's a good outcome- some other collector will find a valuable tome in the charity shop for a few pennies.