Eternal Darkness would make a pretty decent movie
Same for the Max Payne games if it was done right
Of course most of the really good games to movies would have to be a direct conversion of the plot in the game to the big screen, and I doubt that would ever happen.