Games like Mario Bros, House of the Dead, Doom, etc. those games, when turned into films, had no story to begin with so the directors and scriptwirters just made it up.
Resident Evil.... the story is very campy, and saadly, it's just another zombie movie story. they are many out there. Not to say it wasn't a bad movie, it's just not too original.
The MK films... come on. they were rahter silly.
Silent Hill though. It has a very intense story, one you'd expect from a Konami game. the mythology surrounding the character Pyramid Head, the constant shifting between misty and foggy Silent Hill, it's all very compelling.
I think it wasn't only an original story, but it was very faithful to the games, and it wasn't boring. I dunno. If anyone else has seen it, I'd like to know what you think.