I personally liked the Silent Hill movie. It wasn't scary like I thought, and hoped, it was going to be, but it's still a prety decent film.
I personally prefer the Resi Evil films over it though, but that's probably because they have a LOT of action sequences in them.
I never played the Silent Hill games though. I think I had a little go on the PS version (very first game) but, like the Resi Evil games, I've never really got into the genre, not really interested in them.