The most realistic effects are using the Tone Compressor, while if you want surreal Salvador Dali paintings, use the detail enhancer where the chart below shows you how to get things that look like Mars or a bad acid trip.
See Colin Smith’s Tutorial on Photomatix Pro Tone Mapping