I have a soft spot for The Silent Hill movies.... which I know, is dumb, theyre not great
But I cant think of another single film based on a game thats worth a single shit, like any film by Uwe Boll (he needs a good fire cleansing).
As for games based on movies, avoid any LJN (nes , snes) and stick with PS1, Disneys allthough generic were kinda fun, I liked Hercules ^^ and the Die Hard Trilogy is also a kinda guilty pleasure....but I dont know why >.>
Try watching the Nostalgia Critics interpretation of Alone In The Dark, gives you a good idea of what you can expect from any video game movie
