One of my favourites of yesteryear was Wild Bunch a text based game on the Amstrad 464 that could be seen as a fore-runner to the awesome Red Dead Redemption.
Text based games by Simon Avery were also great when I was younger.
In the here and now I like things like Dead Space, Silent Hill, Bioshock, Command and Conquer (PC versions)
What would I like to see? I'd sell my granny for a full on Discworld RPG with the production values of Skyrim (minus the glitches

)
I do know that Terry Pratchet has at least played Oblivion and his daughter writes story for RPG's... Just putting it out there Bethesda.