Well if it's a really dumb tattoo, it's going to hurt for a long time, but not necessarily physically.
A day or two, not more. Might still be sensitive for another week or so, but not sore.
Depends on where you get it and the size of the tat. If it is in an area with more fat or muscle not too painful...a day or two. Get it somewhere that is like skin 'n bone more like a week or so.
It partly depends where you have it done and how quickly you heal anyway :-)
None of mine hurt too much, but my wrist one and foot ones were the worst afterwards because they move most and they get caught on things the most.