I think we all know what the best zelda dance was-
OoT Darunia dance
We see gorons dance a couple times between oot and mm, it isn't terribly dignified.
As I recall, Din from Oos was a dancer. I'm not really sure if we ever actually saw her dance, though.
I also really like the dancers in mm...