Silent Hill
The film is overlong, with too many unnecessary scenes (a lot of the movie seems like pointless running around), but it packs in a few scary moments and offers a nicely ambiguous conclusion.