Yes it can be a hot fantasy, I try to incorporate my piercings and tattoos in
them.

In fact I got my 2nd right nipple piercings due to some play. Caught hitchiking, by a
cop, who took me back to my place, bound me and pierced my nipple...again

I've also had people ask that they want to that on me just for themselves as well, like a private place