I absolutely loved it, yeah its not really that scary but the atmosphere feels straight out of a Silent Hill game in many ways. Generally it really reminded me of Silent Hill with the structure and all, except that its 2D.
It really really depends, some artists and albums are just inherently similar in many of their songs which can make certain albums wear out very quickly. My favorite albums never get old though. I generally really try to listen to new music a lot though to mix it up, its boring to listen to the same thing too much.
Nothing I have seen from the game makes me want to play it. I really wanna know what people see in it. Maybe Ubisoft is just horrible at demoing it but I don't see anything exciting. You drive, you shoot and you hack. Hacking seems very underwhelming, like lifting those road blocks they have shown in every trailer or a small piece of cover it all kinda seems very basic and predetermined. Of course that is all just from watching the few videos that are out, but they are supposed to make me want to buy it and failed in doing so.