I should have replied to this thread 6 months ago, when I had the chance to play T.I.M.E. Stories at BGG.
I absolutely loved it. Just about the most fun 4 hours I've had playing a board game ever. But yes, it's only those 4 hours, until you get expansions.
So I haven't bought it, because it's really the type of game that's better to play at cons, due to the non-replayability of it. But still, I highly recommend it, and I can't wait to play some of the expansions.
I also got Sherlock Holmes: Consulting Detective last year to play with my wife. We've did the first 2 cases and had fun, but for some reason haven't gotten back to do the rest. It's not bad, but T.I.M.E. Stories basically has all the good parts about that game, with a lot of better parts as well, such as actually feeling like a board game.