For me it depends a lot on the tattoo itself, the location, and the lady (or gentleman) bearing it. I really dislike trendy tattoos, or anything trite/overdone; a tattoo should be as unique and meaningful as the individual it's on. I've seen some that are amazing, and some that make me cringe.
I've never been able to think of a tattoo I'd want on my skin forever, so I have none. Besides, I have tons of freckles already, which are like nature's tattoos.