Witches are the only life state I've found compelling enough to play for more than a generation. Fairies look cool, but I just can't get into them for long. I think part of the problem is when the town starts randomly creating new life states (I tend to play in Sunset Valley) sometimes the sims that end up as fairies just seem way out of character with the trickster personality, or they get ridiculous wings. Nancy Landgraab being willing to play fairy games with me, or Connor Frio buzzing around with bumblebee wings, rolling wishes to throw a fairy party? (Which did happen to me in two different save files!) Uh, no. Too weird.
Werewolves and vampires just don't appeal to me at all, so I've never played one. I was thrilled when we got the patch that gave us the option to turn vampires and other life states off so they don't spread through town.
On the other hand, witches I find a lot of fun to play. I had an inappropriate and insane witch who caused lots of mayhem with toadification, love charms, and elixirs. That game was a blast.