Considering how you played VNs, I am sure you will enjoy point and click adventure games.
The Last Express, made bythe guys who made the original Prince of Persia, set on just one train going from Paris to Istanbul, you have to unravel who killed your friend and one giant conspiracy involving some key players from different nations.
Black Mirror, the original, has you playing a young nobleman trying to unravel the mistery behind his father's suicide, an ancient curse that has befallen your family. Has you traveling through different luxurious mansions, rural cities, tombs and so on. Honestly I didn't really like it, but others do, definitely give it a try.
Broken Sword: The Shadow of the Templars, considered to be one of the best P&C adventure games with gorgeous artwork and top tier voice acting, has you unraveling a secret conspiracy between the hassasshins and the templars. It has you traveling on all sorts of places around the word, from Paris to Scotland, to Istanbul and so on. Definitely a must try.
I guess the Myst series might count, but I don't know if they are what you are looking for, maybe also the Gabriel Knight series, but haven't played it. There are some Sherlock Holmes games, but I don't know how good they are. For a non-P&C game, you could also play Deadly Premonition, and extremely interesting and sometimes hilarious game that is just basically Twin Peaks, but made by Japanese(not the first game like this, mind you, the Japanese really really loved Twin Peaks).
Hope this helps.