If you've never played an old-school survival horror but are used to modern ones like Dead Space, you might prefer Downpour.
Silent Hill 2 should not be missed though - If you can endure the crap controls and awkward fighting, it's an awesome game!!!
Not only that, but Silent Hill 3 is in there too, which is probably also better that Downpour.
Personally I'm an old-school survival horror fan, but once I'm finished with the HD collection I think I'll check out Downpour. I bet it'll drop in price very fast.