You can look at the review here of Still Life 2 from the site:
http://adventuregamers.com/article/id,1019
My opinion is that Still Life 2 is pretty mediocre(and I liked the first one a lot) but you might have a different experience with it.
Some games that might fit your criteria besides what's already been mentioned:
Gray Matter
The Longest Journey
Dreamfall
Syberia I and II
The Lost Crown: A Ghost Hunting Adventure
Indigo Prophecy(Fahrenheit in the U.K)
Overclocked: A History of Violence
The Black Mirror series
The Blackwell series
The Frogware Sherlock Holmes games
Gemini Rue
Should be plenty to get you going, kept the list to semi-recent games(with the last ten years or so). Naturally, I'd advise checking reviews of said games before to make sure they sound like something you'd like.
