Another well known artist at the moment is Kat von D. I don't know if she is better known for her art or her appearance, but she has also worked for many celebrities like Kirk Hammett (Metallica), the Green Day and Jenna Jameson (who has a nice tattoo on her back explaining why she does what she does for a living: "I was born to do it").
