Not scifi or fantasy, but have you heard of Pentiment? It's by Josh Sawyer, lead designer of New Vegas. You're an artist in 1518 Bavaria completing your masterpiece at a monastery, when someone gets killed and you must collect evidence. There's much more to it than that, of which I can't speak without giving anything away. However, I can tell you that the game has no combat, it's just exploration and dialogue. The whole game looks like an illuminated manuscript, and you walk around engaging in some of the most captivating conversations ever to be in a video game. The character creation is extremely unique; in the beginning, you pick where you spent your year abroad, what you do in your free time, what you got your Master's degree in, and what your favorite subject was at university. All of these determine your attitude on and knowledge of pretty much every subject in the game. It has one of the most unique speech check systems in any RPG, with entire conversations counting toward convincing someone, showing you what you said right and wrong at the very end. Masterpiece.