Is there any reason to do them other than for exp? Cool story stuff?
Yup. Hard mode for dungeons is not "exact same dungeon, but harder". You go to new places inside the location, fight new enemies, new bosses, and the dungeon "storyline" continues.
As above, Tam-Tara HM is pretty great.