The ugly truth is that most of the output of most photographers will be unceremoniously dumped on their deaths - the proportion rises to almost 100% in the case of non-pro enthusiasts. If this bothers you, be sure to talk ahead of your demise to the archivists of any organizations which might be interested in your work and present to them any of it in which they are interested. For myself, it is almost certain that the handful of pictures I took of David Bowie in my youth (example in APUG gallery) will eclipse and outlast anything else I have done or am likely to do - I find this slightly annoying, but I can't do anything about it. I continue to take pictures for a variety of reasons, not really caring what posterity will think, since I shall be dead when posterity makes its view clear!
My photography is like my singing in the bath, I don't worry too much if anyone else likes it as long as I enjoy it.
Remembering "Minority Report," I suspect that future tombstones will incorporate a continuous loop hologram presentation of the life of the deceased. Maybe if you pay extra you can get the "enhanced" edited version which cleans up some of the less memorable parts and even creates a new version of your life.
On another note, the father of a friend was a keen amateur photographer who took some excellent photographs of his mother. More interesting are the ones he took in London during the second World War. One sticks out in my mind of some wreckage he photographed from atop an adjacent building. My friend has promised to one day let me have a look through his collection. I am hoping there are some negatives in there that he would let me print for him.
Like many others, I do this because I just simply love it. It would be pretty coo I'm sure, but I hold no expectation that my photographs will mean anything to anyone.
My daughter loves the weather, clouds, storms, and the like and wants to be a meteorologist. Since I have acquired a LF system, I hope to produce some cool cloud/weather photography for her to proudly display in her home someday. That form of accomplishment with my photography would be good enough for me.
When I look at old photos, some very old, I become aware of my interest in the captured moment and its value, at least too me, the viewer. I now see others looking at my old photos with that same, or similar, interest and it makes me happy to think that some of my personal work will be viewed with interest by others when I'm gone. It was never my reason for photographing, I do it because I enjoy doing it. My hobby!
Some of my photos have been published in books but they mean little to me personally as I was hired to produce them. That doesn't diminish there value in general though (signature quote).
My personal photography is now only monotone fiber prints because I see the value in that type over all others and I would imagine that many will be around long after I'm gone, at least in the family, for future generations. I think that's a good thought to have in mind!
"Pictures are not incidental frills to a text; they are essences of our distinctive way of knowing." Stephen J. Gould