If it’s an actual large, intricate tattoo with some work in it, that’s another story. I would be extremely suspect of any artist even willing to take such a request — good artists work within a style they’re comfortable with and most would not feel comfortable enough to do a good copy of an intricate piece by another artist.
That said it’s totally fine to get inspiration from other tattoos or even borrow the whole concept into an original piece. Most artists want you to come in with some examples of what you’re looking for.
But tattoo artists are actually artists — most got into it because they’ve been drawing most of their lives and tattooing is one of the ways to make a living as an artist. It’s best to think of a tattoo as commissioning a piece from an artist — it’s actually what you’re doing, and they just take the extra step of putting it on your body.