The intro was overlong, yes, but the true annoyance for me were those kids (Malo and gang). They were constantly talking and swooning and getting captured. I really hated that Ilia (or whatever her name was) was such an integral part of the story. I just couldn't get into it.
Overall, I loved Twilight Princess, especially the last half of the game with all the cool dungeons. I agree with most here, though, that there doesn't seem to be anything enticing that the HD remake adds for $60.