In real life, I don't particularly like tattoos in general, although I respect them for the art that they are. In terms of a game, however, if a character is one that would likely have tattoos then give them tattoos. Personally, I always wanted a partner with a copy of "War and Peace" tattooed on their back. That way I would have some incentive to read old boring classic literature.
Tattoos are hot as fuck! Tattoos and piercings, hell yes. Though I guess it does matter the level of tattoos. Like if it's full face covering, probably not. Though I've also seen some that look really good.