Silent Hill was a pretty good horror movie, I thought (at least until they started explaining stuff about the town, its people and its history); I've never played any of the games, but judging from the screenshots and trailers I've seen it was a pretty accurate representation of the Silent Hill atmosphere.
As for the list provided, I voted Resident Evil. While it wasn't anything like the games (I'd have personally preferred to see someone attempt, once and for all, to make a coherent storyline for the constantly-retconned games), it wasn't a terrible movie in its own right, and managed to get the claustrophobia and jump-scares from the games pretty much spot on.
I think the main problem with game-to-movie translations, though, is how completely differently stories need to be told for the two mediums. Even in a game like Half Life 2, where there are no cutscenes, the structure is very much divided into "event" bits (set-pieces) and "story" bits, and those sections very rarely overlap. In a (good) film, the story and the events are presented together.
