I think the closest real world (as in wide scale commercialization or deployment) of your original idea was Facebook’s automated video they made for each account (assuming they had enough content) playing back your history via photos, friends, events etc. Cant remember the name of that video feature just now.
There’s always a core idea in each product that has some practical value somewhere.
As for real world products: Shutterfly/Snapfish are still looking healthy, and Google Photos is pushing hard their print store, which is where we were eventually heading to. And in the category "real world products that never were" - WhatsApp reached us shortly after the acquisition by FB. They were interested in partnering up with us, until all of a sudden they weren't anymore.
The core idea, as you say, is always there. For us it was the importance of Memory, which will keep on cropping up on many products to come. You just got to be riding the right one. :-)
It all started in a similar way, around 2010, with a lot of free time in my hands and with the help of some fantastic friends who became co-founders. At the beginning it was more of an artsy thing (look at our manifesto [2]), definitely fueled by a love for books and a desire to slow down the merciless wheel of tech. The commercial vein only attracted us later. Fast forward to 2014 and we had a working product, we passed through the Startup zoo (2 incubators and various shows) and managed to raise about $500k.
But sales never took off. As we tried to expand the scope of the product by integrating WhatsApp and other messaging systems, it finally dawned to us just how small the market was. By the time we decided to pivot to a more visual product (ie: Photo-books), money were running out. When we finally closed the company in 2016, I think we had produced a few thousand books, but <10k.
It was a fun ride. Wish you the best of luck!
[1] https://web.archive.org/web/20160131132208/https://memeoirs.... [2] https://www.jamez.it/project/memeoirs/