HDRSoft's Photomatix Pro is the most commonly used HDR plugin in my circles.
However, I have also heard good things about L/R Enfuse
, which is a donationware product. It may be lacking some of the fine-tuning features of Photomatix Pro, but it also supports focus-stacking for macro shots, which is a definite plus.
Wind, Sand and Stars.