I think the cloest I ever played was Road Avenger on the MegaCD which was actually quite a fun game at the time.

I suppose we could consider the superlative Her Story as a modern evolution of the format.