Longest Journey, long time since I've played it but from what I can remember its a very good story and got great reviews when it came out and there is a demo. You play as a female character set in a futuristic world but get drawn into saving an alternative world.
What about the Broken Sword series - again good stories, or the Gabriel Knight games that someone linked on GOG the other day