You'll love
Gorky 17 from LinuxGamePublishing (LGP). It is an turn based, 3D, 3 Quarters top-down, RPG with a story and scenery like Resident Evil. Though, the game's on-the-fly rendering is not up to date. The pre-rendered graphics are just as good as the way Resident Evil used to do it, before they went (mostly) completely real-time 3D. This is my 2nd favorite game from LGP. It would have been number 1 on my list, except that, there is not much replay value. The story kept me going for a couple weeks. So I feel I got my moneys worth.
Here is a demo of that game:
http://demofiles.linuxgamepublishing.com/gorky17/
Another story based game from LGP is
Cold War. You can say it is a Splinter Cell clone, but apparently the developers said it was in the works about a year before they heard of Splinter Cell. You are a journalist during the Cold War, investigating Soviet Russia, when... well you should just get the demo.

Not my favorite game, since I was never a fan of Splinter Cell... but if it is to you, than be LGP's guest.
The demo:
http://demofiles.linuxgamepublishing.com/coldwar/
BTW, if I recall correctly, LGP got the rights to another RPG. And if you take a look at their game record. It should only be of quality.
There are others, but it'll take me a little bit of time to write them down, or remember them. So I'll update this post in the future.
BTW: If you plan on buying one of these games, I suggest you go to Tuxgames.com, where they offer a downloading of the game, as well as the boxed version. Though, for an added 5 USD, I have to add.