Thanks for all the contributions. A few thoughts.
I think whether or not you have direct descendants makes a big difference. If we had kids, which we don't, I can imagine they might enjoy looking at their parents or grandparents history, but I can't imagine our tribe of nephews and nieces felling the same way.
Then there's the medium. My mother has a couple of shoe boxes (whatever happened to them) of photos of relatives and friends. Some of them are real social history of life in a Lancashire cotton town at the beginning of the last century. I'm the only one interested, but at least they are there. Once upon a time I used to keep photo albums, which I still have, but I haven't produced a new one in years. I have a few recent prints and hundreds of stored transparencies, but who's going to look at those? The rest are just ones and zeroes on various electronic devices and they will surely go when I do (and having backups in the Cloud won't make a difference).
As for feeling maudlin. When you're in the back of an ambulance on your way to hospital with the siren going, as I was just a few weeks ago, you might hope for the return journey, but still your mind wanders.
As the refrain of a cheesy country and western song goes:
"It's not what you take when you leave this world behind you, it's what you leave behind you when you go".
But that goes beyond a photo forum
Cheers, Dave