As much as I like fantasy stuff, I wouldn't mind a RPG set in a more 'normal' world, either. Or if it does have the sci-fi/fantasy elements, the story is more centered around how a sudden entrance of sci-fi/fantsay/horror stuff affects the "normal" world, rather than it being or becoming the world, if that makes sense. Or, if you take the alien invasion theme so many FPS like to use as an excuse to shoot a million aliens, a game using the aliens perspective rather than the human one.
I have a hard time really defining what I'd like, tho ... a lot of books/movies w/a fish-out-of-water theme would be hard to translate into a RPG, I think.
Footfall (Niven and Pournelle novel) might be an interesting backdrop for a game theme, where you could switch back and forth between human and alien viewpoints/roles, but again, hard to translate into a RPG probably.