I'd completely forgotten about Sin City, good catch. Yet another panel-for-panel literal adaptation. Also a very good film.
You raise a good point about game adaptations; I think trying to make a movie out of a product in another medium is always tricky, but videogames especially because most of them aren't plot-heavy -- the story isn't the point of the game nine times out of 10. RPGs aside, no one really plays a game for the story; I don't play Tomb Raider for riveting plot -- I play it because it's fun.
And as we discuss this, I see there's another Street Fighter movie. Jooooooy ... *eye roll*