I actually really enjoyed Downpour myself, but it took some time.
At the start of the game (the very early stages of the town), it all just seemed a little odd, and threw it had a habit of throwing a lot of rather un-subtle attempts to be scary at you.
However, as I progressed further, the game ended up crossing into a new territory: unlike the other Silent Hill games, this game went for extreme surrealism in everything it did. Everything that kept happening just became more and more interesting and weird, and it pulled me right into all the madness that was going on. It threw in some simple, yet very strange and clever ideas that gave the game such a bizarre personality that I couldn't help but enjoy it.
The story kept me going, and it did a great job of handling some very dark subject matters (not that the other games haven't.) While some of the reveals were a bit predictable, the game presented them in a good way, which was a big step forward from the other american-developed games.
The only real complain I had about the game was the monsters. They weren't exactly scary (hell, some of them were actually kind of hilarious), and didn't seem to "have anything to do" with Murphy (unlike Silent Hill 2.) Some of the music seemed a little unfitting (most notably the music during combat), but that was hardly a problem.
I even found the game to be pretty scary at times (I played it at night), especially in those dark apartment buildings and such. While the "dark and worn" aspect of the areas is all good, what really got me was this:
In every house and hallway, there always seemed to be something "off" about them, which I thought was very unsettling somehow. It seemed like there might have happened something terrible in certain areas (aside from the monsters and stuff), but you were never completely sure. For me, that was a great scare factor; it was constantly creepy and filled with uncertainty, like the older games.
I don't think it's the new Silent Hill, but as a game alone, I found it very enjoyable.
It seems like the developers really made a big effort of making this something great.
It wasn't as good as Silent Hill 2 (let's face it; nothing will be as good as that), but it was far, far, FAR superior to both Homecoming and Origins (and I even thought Homecoming was an okay game, if nothing that special.) It was flawed at points, with some annoying parts in the combat and some awful screen-tearing and graphical flaws, but that never ruined the essential experience of the game. It explored both old and new ideas of the Silent Hill franchise, which blended together very well. There were also some neat references to older games, none of which seemed out of place for me.
Overall, I had a great time with Downpour, and it's definitely one of the better survival-horror games I've seen in a while.