Hot tattoo designs would translate to exotic, dangerous, bold, and, you got it, erotic! Never, ever mix "cute" and "hot". A smiley or a butterfly would not make your man go gaga over your new tattoo design. The design needs to be strong to give out a feeling of sexiness and power.
