Perhaps you haven't read the thread, but I use LR and it does the same thing. But that's not what I'm looking for. I"m not sure why you (and others, since I hear this all the time) you think media becomes obsolete. Hard drives have been used since I started using computers in the mid-90's. Only the capacity is different. And jpeg/tiff aren't going anywhere. Obsolete is an illusion and is not an issue I'm worried about.
I think the point he raised is important, valid and easily overlooked: I do understand your desire that your most important work should be as easily accessible as possible. Being able to store and access media means you need to have two things in order: a storage method and an access method. This is no different from storing negatives or slides. In the world of computers, this is done by hard- and software. flynz4's post concerns the software side while your proposal focusses on the software side.
He's entirely correct to point out that you can no longer plug in your external SCSI hard drive or your PATA hard drive in a current computer without some extra effort. A significant share of my CD-Rs and DVD-Rs (which I used as a backup medium 10 years ago) contains unreadable files, and I no longer have a built-in optical drive (by choice, I exchanged it for an SSD). Fast-forward 20 years and I don't think people know what to do with my FireWire or USB hard drives. Of course, we solve this by periodically moving data to newer hard drives when we get them, but there needs to be a strategy.
When it comes to legacies, heirs really don't like to figure things out - they're sorting through piles and piles of stuff - "Donate this? Try to sell it to a resale shop? Call in an appraiser and hold an auction?" This is why guests on Antiques Roadshow can come up with such great dumpster finds. Most heirs just don't know what's valuable, or are too exhausted by the process to care.
Sure, there might be another family member (or art historian) who might want to curate the legacy and would like to have the entire Lightroom or Aperture package. The chances of either? Pretty slim.
Honestly, I think you guys are way too optimistic, thinking anyone cares about your most-valued photographs. When my grandmother moved into a nursing home, she gave away a large share of her possessions. Most people cared about pieces of furniture, and only I wanted to have her old photo albums. Honestly, when I die, I don't expect someone to go through my hard drive and peruse it for interesting or useful data. Perhaps I'm just a pessimist.
If I wanted to maximize the chances that the photos are found, I'd (1) use the most common format (jpg) and (2) leave specific instructions. If you don't, you may as well bury your files in a Lightroom/Aperture library. Almost nobody knows the difference between tif and jpg, and those people who do are the ones who likely have no more or less of a problem to navigate folders or a Lightroom catalog. I also don't expect my relatives to go through my collection of negatives.
My strategy concerning my work is different: I have given it away as presents, framed large prints. I'm also trying to make photo books.