Here is one that I did that you most definately have to use HDR. I was in the dark end of a cavern and shot this. It still isn't the BEST quality due to my camera (I had to manually bracket 5 shots, which caused quite a delay between them - movement), but HDR for sure had to be used.
I also don't like the radioactive look, but sometimes I do like to push the image a bit to go for more of an artistic look. I still need to go try to rework this yet again - I want it to be as natural as possible, but I would rather go back and reshoot it first.
Otherwise, the best you would get would resemble something like these:
http://i251.photobucket.com/albums/gg314/jh1882/Hamilton Pool/HamiltonPool039.jpg