I just finished the game a few minutes ago. Seems it ended right when it was starting to pick up steam.
Spoiler:
The plot twist about the killer's identity made
no f*cking sense and almost ruined the game for me. There were a lot of other problems with the story, but that was the worst one. Hated it so much.
Apart from the flawed story there were some technical issues (sh*tty movement controls, screen tearing, sound glitches) that got in the way, but overall I still have to say it was one of the most intense and unique games I've ever played. Having to cut off your own finger was some heavy stuff. I also went through the whole game without any sex or nudity.
I think
Heavy Rain is definitely a very experimental game and while it didn't entirely pay off, I'm happy the developers were willing to take some risks and I'm glad to have played it.