Unfortunately games like Heavy Rain are pretty rare, which is a shame.
Usually in the indie games scene you will find games like Heavy Rain, and a typical attribute of indie games is not super realistic graphics.
Have a look at games like Dear Esther, Kentucky Route Zero and The Walking Dead (by Telltale games, not the other horrible one). They are fairly minimal in gameplay and heavy on character development and story.