I too am a tad tripod-obsessed but the other way around I'm afraid...
So far I did have good results with the "align layers" function of CS3, way better than the tests I made with Photomatix 3.0 (very deceiving, and the "tonemapped" look is quite errrr hard to say the least). As said by Ted Dillard, used with ACR smart objects it sounds quite powerful.
Working mainly with LR I often try Enfuse, but the alignment is not that perfect (way better than Photomatix too, but still some occasional ghosting). It works for some cases and not others, it seems it doesn't tolerate much move between images.
I did think to try TuFuse or Enfuse, but would really like something that doesn't break the LR flow... With that constraint, LR/Enfuse is the best tool I found so far.