I've had my eyes on this game for a really long time now and after christmas is over I'm finally getting it.
I haven't played Heavy Rain yet (don't own a PS3) but I didn't think Fahrenheit (Indigo Prophecy) was more then decent (which is good enough to make it worth your time though). I think Deadly Premonition seems more interesting, time will tell if that assumption is correct.