I'm bias towards them, so I can't be honestly asked this question.
My advice is to find something special to you, some artwork that speaks to your very soul, and of course to ignore the 'fads' that are in strength at that given moment. The sort of, like the above mentioned, barb-wire tat or other meaningless tat such as a sentence, in any language. These tats don't look good, no matter the font or how much you spice up the band of wire, and often will be something everyone will find ridiculous a few years down the track.
OH yes, while I remember, do NOT tattoo a name of a lover! Statistics are not on your side.
But yes, I find a well designed and thought out tat to be a thing of beauty.