Extreme contrast often kills evening or night shots as shadows drown and lights are overexposed. HDR is the resource of choice in some cases. As HDR works with already 3 differently exposed pictures (which most of today's SLRs can do with AEB and continous mode automatically), many more "special" shots are feasible even without tripod.
Please also check in the Picture of the month section - 01/2009