HDR is an adventure in itself. Look in the sample folder in your photoshop CS2 installation for some images to play with the Merge to HDR command (under File/Automate/Merge to HDR). I have experimented with HDR a little and it can produce richer results. In Photoshop, it produces a 32-bit image with a wider range of shadows and highlights than you could normally capture with one shot. If you normally take 3 or 4 shots and try to layer mask them together, HDR is a much more effective method of getting the most out of multiple exposures.
You can make your images more vivid in many ways. Try experimenting with blending modes in Photoshop. Create a duplicate layer and set it to Overlay and adjust the opacity downward to a low %. Try adding a gaussian blur to the layer before you set it to Overlay and you can get subtle glows from your highlights. If its too dark, add another layer in Screen mode to lighten it up. You can add another layer and run the High Pass filter over and set it to Soft Light or Overlay. It's important to adjust the opacity to something reasonable and usually subtle when using blending modes. Vivid Light makes your image look ridiculous but if you turn it down to 3 or 5% on some images, you get a slight effect. And, of course, you can always layer mask the effects and only hit the areas that need it. And use Saturation Adjustment Layers to saturate each part of the image to appropriate levels (Adjustment Layers are very handy, g00gle them if you aren't familiar, they are non-destructive, can adjust them anytime, and have a layer mask).