Semi-Obscure Nintendo - Puck as Creepy Zelda Fairy (Apr. 2016) (Patreon)

This fairy design is iconic and disturbing.  Any heterosexual male who's ever played one of the above-mentioned Zelda games can attest to the fact that the fairies are simultaneously sexy and terrifying.

(Hyrule Warriors admittedly tilted the scales heavily into the sexy territory, what with the lack of low-polygonal weirdness.)