I love Heavy Rain. It has flaws (but in all honesty so do all games), but it is brilliant for trying something a little different just like quantic dream's previous game, Fahrenheit (or Indigo Prophecy if u are american), except this time it doesn't go off the rails in sci-fi weirdness.
Most of the game isn't "exciting" in the traditional sense although anyone who has played the game should agree with me that there are moments of extreme excitement (I mean Ethan on the motorway for instance) where the style of the game helps to heighten what you experience.