I actually though the Silent Hill movie wasn't bad, though it definitely wasn't scary at all, which is kind of a failing for a horror movie. It was more grotesque, which is always interesting as a study of the reactions to the grotesque, and it was a little bit narmic.
And I still can't get over the first two Resident Evil films. The third one was utter bollocks and I haven't seen the fourth, but the first two I maintain weren't awful. They weren't particularly good, not by a long shot, but they didn't fall into bad territory and they weren't So Okay They Were Average either, which only leaves, good, or at least enjoyable for some mindless fun.
I used to like the first Tomb Raider movie, until I played the games again and read the comics (when I first watched the movies it had been a while since I played with Lara) and then I realised just how much I hated the way they characterised Lara in the movies.
I also liked Spirits Within when I first saw it but have since realised how bad it was, didn't think Advent Children was too bad (but then I also liked Dirge of Cerberus so what do I know), quite liked the first Pokemon movie and utterly hated Max Payne.
So that about sums it up.