well yeah I think in general people play games for the gameplay not the story, even when there are good characters and story (like GTA), people like them because they are playing it, not because they're watching it. Similar thing to like how books for games are not very popular apart from the most hardcore fans, because most people don't really care. over 100 million people have bought World of Warcraft and yet not many turned out to see the film.
And yeah RF would be cool. I think the story lends itself quite naturally to film - rebelling against a tyrannical government, in a sci-fi setting that's been used before. I mean Total Recall has the same thing, a government encouraging people to come to Mars and then oppressing them and crushing the rebel uprising. Although knowing hollywood it would probably be turned into a YA movie
I've always thought if I could have one job it would be to be a film director and make a big budget Red Faction movie.