Mellow Ezlo
Spoony Bard
The Great Fairies themselves in Ocarina of Time are downright awful looking, but the fountains are top notch. Same goes for Majora's Mask except that game gets extra points for the Stray Fairy quests and the rewards (for the most part).
The Wind Waker has my personal favourite Great Fairy design, especially the Fairy Queen. I also like how distinct the Fairy Islands are, but the fairy rewards are mostly just upgrades. Lost points for creativity.
So in terms of fountains, and rewards, Ocarina of Time and Majora's Mask take the cake, but in terms of actual fairy design, The Wind Waker wins.
The Wind Waker has my personal favourite Great Fairy design, especially the Fairy Queen. I also like how distinct the Fairy Islands are, but the fairy rewards are mostly just upgrades. Lost points for creativity.
So in terms of fountains, and rewards, Ocarina of Time and Majora's Mask take the cake, but in terms of actual fairy design, The Wind Waker wins.