I was on the fence about Heavy Rain ( actually leaning towards not getting it) when I downloaded the demo and loved it. Every single game I have ever played a demo for I had already made up my mind about whether or not I was gonna get it. This demo is the first to change my mind about a game.
Add this to the fact that I frequently hear people saying that X game is much better than it looks in a demo and I am quite surprised. A demo should make people want to buy your game and then find out it's rubbish after you get their money.
On a side note I got a pleasant surprise from a Co-worker today who was going on about the game after he too downloaded the demo. This was a surprise to me since he might be what you would call a casual or traditional gamer (he like FPS's, sports games and fighting games hates RPG's etc)