For my general opinion on Twilight Princess, check my review of the Wii version.
Regarding the HD re-release, it isn't a major upgrade really. Most of the improvements were focused on the visuals, so you can't go wrong playing any of the available versions of the game. Recommended.