Heavy Rain was great, up until the twist, which was a pretty predictable twist, but still bastardised the story narrative of a handful of the earlier levels.. Beyond I really didn't mind the story at all, but some of the chapters were great, others were a total chore, even for an adventure game. Net result being I had no desire to replay the game in it's entirety.
Fahrenheit of course is now really dated. I never finished it but I remember of it was some good levels (like the opening level) combined with some mundane ones (this all sounds like Beyond Two Souls), and I understand the twist is a real letdown. Heavy Rain I think is the best allround. I don't really remember thinking any of the levels were that weak after the slow start.