I think it's fine to an extant. Too many piercings kind of turns me off but I can't say anything about tattoo's as I have many myself. Tastefully done? They can look just fine. As far as ugly or hot? That's a persons personal preference.
Depends on the girl, depends on her style, depends on the tattoos, depends on the piercings, depends on guys' preferences. Long story short: It depends.
It all depends on what and where they are.