Awful. The acting is poor even from Sean Bean, the writing sucks, it's way too short and congested with useless story crap that misses the point of Silent Hill.
There's some decent monster design and a cool scene with a spider monster made of manequins. The 3D is also really good but useless.
Pyramid swords fights a monster which was retarded.
"Silent Hill: Revelation fundamentally misunderstands the appeal its source material." - Quote from a review not gonna bother trying to find again.
The ending would have been cool had the movie been decent but being such trash it came off as very bland.
That's my quick 2am sum up might add more and/or answer questions later.