I don't think you can say if it looks like a good game without playing it. This applies for any game because a great looking trailer (gameplay or prerendered) can look great but the game itself can be awful. That said, I feel Hatred is one of the rare examples where the trailer fairly adequately informs you to what the game is, and while that doesn't tell you if it will be a good game, it tells some people that they will not like it automatically due to the content. I think, based on the trailer, the game has a lot of potential for a few niche audiences and I am a part of that niche audience. I personally enjoy extreme human behavior, serial killers fascinate me and the idea of a game letting you (possibly) be put directly in the shoes of one is very interesting to me. That said, I cannot say it will be a good game because I don't know what the game is. My assumption at the moment is that the game will be like POSTAL 1, you start out with a gun, kill people, cops come, you kill them, eventually you die and then you can try again. If that is it, I doubt I will like it, it it is simply a hold-out game it would probably just be like trying to survive a high wanted level in GTA, which is fun for a bit but gets old.
The destructo-physics mentioned in the trailer could be interesting, but I feel the isometric perspective will limit their use, it will be interesting to see how they play into it and if they actually work, if they do then great but I am not interested in the game for destructo-physics, I have Battlefield 3 for that.
Another thing I think worth mentioning is that I don't expect Hatred to be a "fun" game. There is a fun sort of cathartic violence, I really like playing Brutal Doom but I don't think Hatred is going to be that sort of game. It might mechanically be similar but the tone and idea behind it will prevent it from being carefree fun like Doom and be more introspective and interesting. It reminds me of Telltale's Walking Dead series, I played through season one and had 0 fun the entire time. However I still recommend others play through it because while it wasn't fun or entertaining, it was interesting and worth experiencing. I will eventually get season 2 but knowing how season 1 played out, I am waiting for the perfect time to have a good 4 hours of depression because that was the experience I got from season 1.
Final little side note: I have been wanting to bring this up for a while now so I'll do so now. People ripping on the dialogue in the trailers for Hatred aren't as clever as they think they are. The dialogue sounds corny and cliche to lots of people but based on my (VERY LIMITED) research of mass murderers/shooters (mostly columbine research), that dialogue actually fits almost eerily perfectly with how SOME mass murders think. One line in the second trailer is about how people feel safe inside their homes is almost word-for-word a line I read in a book about a school shooter. Lots of people comment how the dialogue sounds all angsty and childish but that doesn't mean it is inaccurate. My belief is that more sophisticated dialogue would be illogical, the (real world) act of going out and killing people is very immature, its an immature way of dealing with your problems. In that sense the dialogue of the trailers fits the protagonist's motive almost perfectly. So the dialogue isn't really weak, its actually disturbingly accurate to some real-life people. Makes me hope the devs are actually pursuing the idea of being this evil man instead of simply making a game about shooting innocent people to exploit controversy. Kinda wish the devs would do a BTS sort of thing describing the gameplay more because as it stands now I have no intention of preordering the game despite it being something I am very keen on paying close attention to.