Every once in a while I find a shot where HDR works. But, most of the time I throw away any attempts to use it. I normally take 3 pictures for the set - 2 clicks apart. Then I do not use an automatic HDR processing mode. I use Photomatix Pro. I work with the image to try to get it to be as real as possible but pull things out of the shadows a bit.
He is one for example
It is fun to play with, but not a normal image.