Does the upcoming Leisure Suit Larry game count?
However, many of the advances in technology have been mean to speed things up to where that sort of adventure game can be done as a first-person in 3D; rendering a mobile point-of-view requires processing power while rendering a mostly stable third-person POV with few moving elements can be done by a 386SX.
This is not to say that todays games always lack puzzle elements or decent storylines, but merely that we have used technology to turn what used to be an “outside looking in” experience into an immersive one. Of course, as they are easier to produce, they are still quite popular among smaller indie developers. Proof and more proof (that second one usually does indie games, not music, but I think their next bundle is up soon.)